Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “adviser” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

176 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
adviser1113578(None) 
advise10139221advise_
advised12136041advised
advisee11147151advisee
advisers12135001advisers
advises11138971advises
advisor11134161advisor
admirer1035522admirer
advice12107882advice_
advices13136932advices
advisees12154132advisees
advisors12143902advisors
advisory15132942advisory
deviser114212392deviser
paviser12489092paviser
reviser104114662reviser
abaser86414343a_baser
abider95314463a_bider
abuser85413683a_buser
accuser11347933accuser
achier113914263achi_er
acrider1038623acrider
adapter1036173adapter
adder75419593ad__der
adducer1184163adducer
adepter1036113adepter
adherer1137573adherer
adieu6417423ad_i_eu
adjurer1534823adjurer
adjuster1644353adjuster
admire949933admire_
admired1135703admired
admirers1134713admirers
admires1038663admires
admitter1135113admitter
admixed1833733admixed
admixes1765963admixes
adonises92611433adonises
adopter1036763adopter
adorer74713453ad_orer
adorner8246983adorner
adroiter946193adroiter
advancer1443493advancer
adverb12265413adv__erb
adverse1145953adverse_
advert103215783adv__ert
advertiser1443613advertiser
advisedly1741953advisedly
advising1336153advising
aegises8311373aegises
aerier64823153aeri_er
affixer2033913affixer
aider65431133a__ider
aimer75926823a__imer
airer54927893a__irer
airier64619363airi_er
aiver85725163a__iver
aliner65621983a_liner
alvine94614583alvine_
amasser9418733amasser
amuser84712623a_muser
anise55129703a_nise_
anises64826693a_nises
antisera849183antisera
antisex1439693antisex
antsier7410773antsier
anviled1138953anviled
apposer1147483apposer
appriser1246783appriser
aquifer1934883aquifer
aquiver1934753aquiver
arbiter939933arbiter
arider74717743a_rider
arise56436433a_rise_
arisen65316793a_risen
arises65233803a_rises
armiger1036253armiger
arouser74514423arouser
arrises71617583arrises
arriver10117793arriver
artier63419733arti_er
artsier768943artsier
ashier94714833ashi_er
aspirer967903aspirer
aspises9611643aspises
assister836753assister
atomiser10268153atomiser
aver75931883a_v__er
aviso85713963a_vis_o
avisos95410483a_visos
avoider1155813avoider
avoset9315673a_voset
avower1236823a_vower
awaiter1057443awaiter
axised14438963a_xised
axises134413993a_xises
bruiser9349573bruiser
caddised13315893caddised
caddises12329353caddises
canvaser13276563canvaser
caviler1249063caviler
cruiser93410433cruiser
daiker115113033_daiker
daises74318983_daises
davies105020513davi_es
deicer94114413_deicer
denser74115193_denser
devise104215753devise_
devised123712563devised
devisee113812713devisee
devisers12339863devisers
devises114116763devises
devisor11357043devisor
dicer85426423_d_icer
diker105524553_d_iker
dimer85625603_d_imer
diner65632903_d_iner
direr64927073_d_irer
diseur738843_d_iseur
diver94827803_d_iver
divider12278953divider
diviner11369883diviner
divisor11345573divisor
dorser74819183_dorser
doser66228563_d_oser
dosser74417973_dosser
douser75621633_douser
dowser104716083_dowser
drier64423963_dri_er
driver104714493_driver
duiker114110593_duiker
edgier8469733edgi_er
envier939673envi_er
eviler94811893_eviler
faddier1237783faddi_er
idoliser945043idoliser
inviter104112313inviter
jivier16438613jivi_er
kaiser103610373_kaiser
lavisher1445083lavisher
levier94013873levi_er
livier97514593livi_er
mavises122812993mavises
miser75430403__miser
parvise124211693parvise_
parvises133911913parvises
pavise114714803pavise_
pavisers13387443pavisers
pavises125315493pavises
poiser84217243_poiser
praiser93413943praiser
raiser66620103_raiser
ravisher1465463ravisher
reviler104314973reviler
revise94019743revise_
revised113815483revised
revisers113511933revisers
revises104220533revises
revisor10388733revisor
reviver134411373reviver
riser55431053__riser
savvier1335483savvi_er
seiser65318343_seiser
unadvised1443283unadvised
unwiser1037123unwiser
upriser9218763upriser
vier75428153__vi_er
viler86324163__viler
viper105017303__viper
vise75632673__vise_
vised95518763__vised
vises84427773__vises
visor82512833__visor
vivider14265623vivider
wavier124613083wavi_er
wiser85522803__wiser

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271766.03322215.6
3Display Results1761760.0762315.8
 (SQL Overall)1786911766.51527427.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.