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 “egotist” 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.

131 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
egotist841127(None) 
egoist7612281ego_ist
egotism1038351egotism
egotists937061egotists
agonist82615402agonist
demotist11311842demotist
egoism977472ego_ism
egoists887072ego_ists
egotisms1146682egotisms
egotistic1246132egotistic
elitist7414912elitist
ergotism1146272ergotism
erotism9312302erotism
etatist7415032etatist
exotism1638122exotism
nepotist1059232nepotist
protist9320222protist
vegetist1257392vegetist
ageist7315383ag_eist
agist66325583ag__ist
agonise83112693agonise
agonists9289833agonists
agoutis8286873agoutis_
altoist7313393altoist
amorist9317643amorist
aorist64827873_aorist
artist64125543_artist
atomist92915763atomist
autist64324943_autist
azotise1637073azotise
baptist11311873baptist
chutist1239453chutist
cultist91412713cultist
demonist11413463demonist
demotists1247323demotists
dentist8316743dentist
dhotis1038973dhotis_
dotiest83717453_dotiest
ebonise939613ebonise
egest65222343eg__est
egis56520653eg__is_
eglomise1143933eglomise
egoisms1065953ego_isms
egoistic1147103ego_istic
egoless836983egoless
egos55821653ego__s_
elegist81311973elegist
elitism939763elitism
elitists848543elitists
emotes84620283emotes_
emoting10313563emoting
emotion9711303emotion
emotive1239193emotive
emptiest1278103emptiest
enlist6417043e_nlist
enokis103010273enokis_
enosis63816423enosis_
entwist1048803entwist
eonism83213533e_onism
epeeist938863epeeist
ergotic1049723ergoti_c
ergotisms1245303ergotisms
ergots74512373ergot_s_
erotic82620273eroti_c
erotica92811513erotica
eroticist11712073eroticist
erotics91914153erotics
erotisms10310163erotisms
erotize16311663erotize
etatism9610293etatism
eugenist949623eugenist
eulogist949043eulogist
exegetist1744873exegetist
exist124618943e__xist
exorcist1746873exorcist
exotic153112653exoti_c
exotica16257603exotica
exoticist1887993exoticist
exotics16229193exotics
exotisms1746723exotisms
florist10314243florist
flutist102910783flutist
foist85730973_fo_ist
footiest113514913footiest
gist56046763_g__ist
gnomist1049133gnomist
goatish1139563_goatish
gooiest82813883_gooiest
goriest82218743_goriest
goths96513003_goths_
goutiest93013883_goutiest
goyish13379013_goyish
grist65529873_g_rist
hedonist1249553hedonist
helotism1347703helotism
hoist86433213_ho_ist
holist94723213_holist
hootiest113115643hootiest
ironist7314843ironist
joist125125653_jo_ist
leftist10279353leftist
legalist9512393legalist
legist71315253leg__ist
lookist1139563lookist
lutist64317553_lutist
melodist1149743melodist
moist76033583_mo_ist
monist84324983_monist
negotiant1045253negotiant
negotiate1045533negotiate
nepotism1246483nepotism
nepotists1145743nepotists
oboist8312683obo_ist
odist6421913__odist
ologist8313833ologist
pietist9414033pietist
protest9317533protest
protists10313363protists
remotest103310723remotest
rightist12159143rightist
rigorist949123rigorist
rootiest83115593rootiest
rotis56327063_rotis_
semitist10413323semitist
sootiest84016753sootiest
statist7317723statist
tenorist8413023tenorist
utopist938693utopist
vegetists1344483vegetists
violist10312143violist
zootiest173311213zootiest

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.440406115.9
2DLD Change Limit1340271316.17021722.4
3Display Results1311310.0502620.0
 (SQL Overall)1786911316.66026830.5
 
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.