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

123 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
jabirus169457(None) 
jabiru15125511jabiru_
babirusa1241922babirusa
habitus12338172habitus
jaybirds2142822jaybirds
nairus639142na_irus
sabirs85414632sabir_s
abacus10349763_abacus
abides94719893_abides
aborts84916183_aborts
abortus9397913_abortus
abris75722603_ab_ris
acarus8312193_acarus
acinus8311253_acinus
adieus739633_adieus
airbus848343_a_irbus
airns55521033_a_irns
airs46447423_a_ir_s
airts55626343_a_irts
amicus103810003_amicus
amirs75924923_amir_s
animus84211613_animus
babies106123653babi_es
babirusas1351693babirusas
babirussa135863babirussa
babus95620333bab__us
bairns86710873ba_irns
birds85421333__birds
birks114920303__birks
birls74023163__birls
biros75325133__biros
birrs74917103__birrs
cabers105023923caber_s
cabins104418923cabi_ns
cairds96411513ca_irds
cairns85313303ca_irns
carious93320283carious
catbirds1344203catbirds
chirus114615693_chirus
cubitus11346783cubitus
dubious1036893dubious
fabrics1436093fabrics
fairs85825443fa_ir_s
fakirs13468083fakir_s
faqirs18456033faqir_s
fatbirds1443413fatbirds
gabbros12124653gabbros
gabies93820733gabi_es
gabions102410053gabions
gambirs12359083gambir_s
habits113014653habi_ts
habitue12266703habitue
habitues13306413habitues
habus106317143hab__us
haikus13538293ha_ikus
hairs86225173ha_ir_s
halitus10339963halitus
jabbers183610583jabbers
jabots1538883jab_ots
jabs135830093jab___s
jacobus1843173jacobus
jagers144415723jager_s
jagras1438463ja_gras
jailbirds1942613jailbirds
jails125422943ja_i_ls
japers154616173japer_s
jarinas143712183jarinas
jarls126120963ja__rls
jars117338353ja__r_s
jaybird2043123jaybir_d
jibers155912883jiber_s
jubiles16289373jubiles
kabars124513953kabar_s
kabikis1243863kabikis
kafirs13306983kafir_s
labarum1166013labarum
labarums1254503labarums
labials9299873labials
labium10410243labi_um
labors84016413labor_s
labours9349893labours
labrum1057423lab_rum
labrums1175853lab_rums
lairds74711613la_irds
lairs55425873la_ir_s
mairs76228303ma_ir_s
manitus9310923manitus
maybirds1643323maybirds
mbiras1077153_mbiras
nabis76020583nabi__s
nadirs7109003nadir_s
nairas6312783na_iras
nairu5413813na_iru_
pairs75325833pa_ir_s
papyrus1444063papyrus
rabies85226023rabi_es
radius73914873radi_us
rubious938283rubious
sabers85224733saber_s
sabines94318483sabines
sabins85521983sabi_ns
sabir75917003sabir__
sabras85116363sab_ras
sabres85520863sab_res
sanious7514103sanious
satires72617573satires
scabious1246593scabious
seabirds1164403seabirds
subvirus1344333subvirus
tabards10310383tabards
tabers84621573taber_s
tabors84517113tabor_s
tabours94110093tabours
tabus74820923tab__us
tapirs84113173tapir_s
vairs85019133va_ir_s
various103113103various
varus85921183va__rus
virus85316843__virus
wairs86424063wa_ir_s
walrus956433wa_lrus
yairds10448023ya_irds
zaires1539703za_ires

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 Limit1340271236.61020276.4
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.06225303.2
 
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.