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

126 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
jerboas163616(None) 
jerboa1535631jerboa_
jeroboam1943602jeroboam
jeroboams2052472jeroboams
terbias9310742terbias
yerbas11119292yerb_as
aerobat9514473aerobat
aerobats1049843aerobats
aerobes9311493aerobes
airboat9512133airboat
airboats1047283airboats
arbors84717883_arbors
arrobas969213arrobas
balboas113710073balboas
bebops1237623be_bops
berthas12398763berthas
bilboas11438733bilboas
boas66150833___boas
burbots1168673burbots
carbons115418943carbons
carboras12311583carboras
carbos105122263carbo_s
carboys144711783carboys
ceibas1038503ceib_as
cerias83321983cer_ias
ceros74726073cer_o_s
cerous85821203cer_ous
derbies103016053derbies
dermas94116813der_mas
ebons74316093_e_bons
elbows1196723_elbows
emboss1087383_emboss
embows1396823_embows
eras45441503_er__as
ergots74512373_ergots
ericas8315463_ericas
eros45238453_er_o_s
errors63311313_errors
feijoas1742323feijoas
ferbam1339003ferb_am
ferbams1435743ferbams
ferias95020393fer_ias
ferrous1049803ferrous
ferulas103110753ferulas
fervors1336233fervors
genoas74013623ge_noas
gerberas1144963gerberas
gerbils1037303gerbils
harbors12412413harbors
herbal112513493herb_al
herbals122710613herbals
herbs105520503herb__s
heriots10312063heriots
hernias10310773hernias
heroes94923833her_oes
herons94820543her_ons
heros84930863her_o_s
jabots1538883j_abots
jargons1558203jargons
jarinas143712193jarinas
jealous1438093jealous
jebels15418913je_bels
jellos134714283jello_s
jereeds15326393jereeds
jerids142810943jer_ids
jerkers18287083jerkers
jerkies183411583jerkies
jerkins18358253jerkins
jerks166514893jer__ks
jerrids15277743jerrids
jerries143817513jerries
jerseys1733243jerseys
jetbead1742983jetbead
jetbeads1842483jetbeads
jetons134512613je_tons
jetsoms16124723jetsoms
jettons1437273jettons
jojobas1542233jojobas
jubas144614223j_ub_as
jumbos17379123jumbo_s
jurors1338283jur_ors
kebobs14427293ke_bobs
kerbs115013673kerb__s
kerrias11289513kerrias
lesbos837403lesbo_s
merlons93311273merlons
merlots92710123merlots
nerols6914893ner_ols
nervous1037143nervous
pereons92815003pereons
pergolas1158233pergolas
periods10312243periods
pernods1038483pernods
perrons93115483perrons
personas102511883personas
persons93717013persons
proas75028803_pr_oas
rebops10311433re_bops
reroofs1037943reroofs
serious73616283serious
sermons9311783sermons
serosa6313023ser_osa
serosas7312663serosas
serous65023563ser_ous
serows96016393ser_ows
servos93812723servo_s
terbia8311153terbia_
termors94712773termors
terras63516973ter_ras
terrors73112213terrors
turbos8910783turbo_s
turbots988023turbots
urbias839093_urbias
verbal112513663verb_al
verbals121910743verbals
verbenas1345343verbenas
verbids13259203verbids
verbose1237753verbose
verbs104614393verb__s
verglas1137813verglas
veritas103012753veritas
versos93812803verso_s
yerba101010763yerb_a_
zebras1737853ze_bras
zeroes154314343zer_oes
zeros144918113zer_o_s

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 Limit1340271266.78019768.0
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.23224708.4
 
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.