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

251 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
gerbils103730(None) 
gerbil938341gerbil_
derails84216392derails
derbies103016052derbies
ervils948772_ervils
garboils1145662garboils
gerbille1144612gerbille
gerbilles1244012gerbilles
grails77518782g_rails
herbals122710602herbals
perils84121852per_ils
serails73318362serails
terbias9310742terbias
verbals121910742verbals
verbids13259202verbids
verbile1249862verbile
verbiles1338922verbiles
aerials74017553aerials
aeries64737783aer_ies
aerily93017013aer_ily
aerobics1246833aerobics
argils75213623_argils
arils58732203_ar_ils
barbels114514433barbels
barbies114519593barbies
bedrails1136293bedrails
berlins93216013berlins
berries94423553berries
beryls11107883ber_yls
bewails1277553bewails
bezils1711310603be_zils
brails84621293_brails
broils84114173_broils
bulbils11338333bulbils
cebids11439173ce_bids
ceils75019403ce__ils
cercis104614493cerci_s
cereals9313173cereals
cerias83321983cer_ias
chervils1644553chervils
corbeils12358073corbeils
corbels113813593corbels
corbies113520123corbies
darbies104216983darbies
debits94214503de_bits
debris93311493debri_s
deils65722863de__ils
dentils84115583dentils
deorbits1144613deorbits
derail74218813derail_
dermis94717163dermi_s
derries83124623derries
derris73615273derri_s
details84214043details
devils104412813de_vils
drails74716953_drails
eerily92913563eer_ily
emails84412343_emails
erbium1038083_erbium
erbiums1135463_erbiums
ervil8310303_ervil_
evils84114263_e_vils
febrile1237153febrile
ferals94216643fer_als
ferbams1435743ferbams
ferias95020393fer_ias
ferlies103216693ferlies
fermis114313503fermi_s
ferrels10248623ferrels
ferries103521083ferries
fertile10311733fertile
fibrils1236843fibrils
forbids13268263forbids
frails93716473_frails
gabies93820733g_abies
gambias125010733gambias
gambirs12359083gambirs
gambits12399723gambits
gambols1238593gambols
garbing113613273garbing
garble94118453garb_le
garbles104016923garbles
garboil1036513garboil_
garbs86321413garb__s
garlics1038013garlics
gels56836103ge___ls
gemmily1534603gemmily
genies75324943ge_nies
genips9469943ge_nips
genius74512923ge_nius
gentil74115123gentil_
gentile83515293gentile
gentiles93713523gentiles
geoids8369843ge_oids
georgics1242873georgics
gerahs1039413ger_ahs
geranials1045913geranials
geraniols1044743geraniols
gerbera1034773gerbera
gerberas1144963gerberas
gerents82612923gerents
germans1079473germans
germens1078633germens
germier10309543germier
germiest11249923germiest
germina1038503germina
germs85118873ger__ms
gerunds935183gerunds
gherkins1643993gherkins
ghiblis1353343ghiblis
gimbals12257823gimbals
girlies83013703girlies
girls64518393gir__ls
globins10278953globins
gobies95418063g_obies
gomerils1146793gomer_ils
gorals76917653gor_als
gorily10612503gor_ily
graals74112913g_raals
grail64622873g_rail_
grains74223093g_rains
grebes93813613greb_es
gremials1136133gremials
grids75321393g_r_ids
grigs75318193g_r_igs
grill64617893g_r_ill
grills74314803g_rills
grilse7399503g_r_ilse
grins65427223g_r_ins
grips85520133g_r_ips
grits65529583g_r_its
groins73917203g_roins
growls104711113g_rowls
gruels73910153g_ruels
gumboils1343893gumboils
gurries83515953gurries
heils85222193he__ils
henbits12177003henbits
herbal112513493herbal_
herbier1239593herbier
herbiest1339993herbiest
herbs105520503herb__s
herdics13249523herdics
herls85226433her__ls
hermits12312143hermits
hernias10310773hernias
heroics122912003heroics
heroins103518013heroins
herries104025073herries
jebels15418913je_bels
jerboas1636163jerboas
jerids142810943jer_ids
jerkies183411583jerkies
jerkily2134623jerkily
jerkins18358253jerkins
jerrids15277743jerrids
jerries143817513jerries
jezails2334163jezails
kebbies1537253kebbies
kerbing14308483kerbing
kerbs115013673kerb__s
kermis124012393kermi_s
kernels11417953kernels
kerrias11289513kerrias
kerries113317913kerries
kevils13358333ke_vils
lentils73912973lentils
mercies113817563mercies
merits8320873mer_its
merlins93015813merlins
merls77423903mer__ls
merrily1238633merrily
nereids838743nereids
nereis6315343nerei_s
nerolis71012773nerolis
nerols6914883ner_ols
nervily1336863nervily
newbies12147423newbies
orbits84211443_orbits
overbids14248903overbids
overbill1337283overbill
overbills1446603overbills
overboils1436623overboils
parboils1237433parboils
pencils113011773pencils
pensils92811593pensils
peril75425953per_il_
peris75537073per_i_s
perkily1637813perkily
permits11314003permits
perries93226603perries
prebids12399883prebids
prebill1138803prebill
prebills1237293prebills
preboils1267293preboils
rails55937403__rails
rebels84518133re_bels
rebids94015533re_bids
rebill84713253re_bill
rebills93510623re_bills
reboils94111723reboils
recoils93814873recoils
remails94714563remails
renails74917263renails
reoils64516873re_oils
rerigs74014793rer_igs
rerolls739943rerolls
resails74616743resails
retails74718973retails
roils54826793__roils
serail64222673serail_
serais64326133serai_s
sereins73716123sereins
serials73919743serials
series64540973ser_ies
serifs94017053ser_ifs
serins64029673ser_ins
serries73925353serries
servals103410743servals
servile10310643servile
strobils1046563strobils
tenails73713923tenails
terais64023513terai_s
terbia8311153terbi_a
terbic10410963terbi_c
terbium1147293terbium
terbiums1245423terbiums
tercels94110363tercels
terries73425633terries
territs72714503territs
tertials8510073tertials
trails64622513_trails
turbits969233turbits
twibils1253113twibils
urbias839093_urbias
veils84918803ve__ils
verbal112513663verbal_
verbid122311313verbi_d
verbify1834993verbify
verbs104614393verb__s
verdins112812333verdins
verily122616053ver_ily
vermeils1374813vermeils
vermis114214963vermi_s
vexils1647173ve_xils
weevils1384683weevils
wergild1234043wergild
wergilds1342653wergilds
wormils1236733wormils
yerbas11119293yerb_as
zorils153810883zor_ils

Search took 8 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 Limit1340272516.64020184.8
3Display Results2512510.0962614.6
 (SQL Overall)1786912517.14225019.7
 
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.