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

156 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
jabiru1512550(None) 
jabirus1694571jabirus
jaybird2043122jaybird
nairu5413812na_iru
sabir75916992sabir_
sabirs85414622sabirs
abide86223703_abide
abort76133583_abort
abri65522213_ab_ri
abris75722603_abris
adieu6417423_adieu
afire86215913_afire
air38058393_a_ir_
airn46433833_a_irn
airs46447423_a_irs
airt45757783_a_irt
airy75734153_a_iry
amir65129743_amir_
amirs75924913_amirs
babied114913503babied
babier103515563babier
babies106123643babies
babirusa1241923babirusa
babu85829223bab__u
bairn77515533ba_irn
bird76128313__bird
birk106326853__birk
birl65830463__birl
biro66131203__biro
birr66022353__birr
caber95126833caber_
cabers105023903cabers
cabin94820933cabi_n
cabins104418913cabins
caird85717233ca_ird
cairn75717513ca_irn
catbird1235243catbird
chiru105317153_chiru
dairy97016303da_iry
fabliau1244903fabliau
fabric1337833fabric
fair76332523fa_ir_
fairs85825443fa_irs
fairy115318283fa_iry
fakir125111493fakir_
fakirs13468083fakirs
faqir17548643faqir_
faqirs18456033faqirs
fatbird1344033fatbird
gabbro11114953gabbro
gabies93820723gabies
gabion93211023gabion
gambir11509753gambir_
gambirs12359073gambirs
habile11515203habile
habit103027013habi_t
habits113014643habits
habitue12266703habitue
habitus12338173habitus
habu97325483hab__u
haiku126113693ha_iku
hair76330143ha_ir_
hairs86225173ha_irs
hairy115316833ha_iry
haleru94212073haleru
jab128444113jab___
jabbed184213483jabbed
jabber173713643jabber
jabbers183610583jabbers
jabbing19319413jabbing
jabot14321513jab_ot
jabots1538883jabots
jabs135830093jab__s
jading154214023jading
jadish17319903jadish
jager134318133jager_
jagers144415723jagers
jagra1338173ja_gra
jail115529093ja_i_l
jailbird1842703jailbird
jails125422943ja_ils
jambeau1843773jambeau
jambing19328523jambing
japer146218883japer_
japers154616173japers
japery18439143japery
japing165013573japing
jar107646153ja__r_
jarina134014063jarina
jarl115828133ja__rl
jars117338353ja__rs
jawing174414963jawing
jaybirds2142823jaybirds
jiber145115703jiber_
jibers155912883jibers
jibing16379613jibing
jubile152910253jubile
kabar114815553kabar_
kabars124513953kabars
kabiki1134773kabiki
kafir12488903kafir_
kafirs13306983kafirs
labara83712893labara
labarum1166013labarum
labia75219003labi_a
labial84714333labial
labile8315213labile
labium10410233labium
labor75117313labor_
labors84016403labors
labour84210933labour
labra75415463lab_ra
labrum1057423lab_rum
lair45934153la_ir_
laird65417793la_ird
lairs55425873la_irs
mair66133763ma_ir_
mairs76228293ma_irs
manitu8315823manitu
maybird1543993maybird
mbira977953_mbira
nabis76020573nabi_s
nadir61012973nadir_
nadirs7109003nadirs
naira5314743na_ira
nairus639143na_irus
pair66031513pa_ir_
pairs75325833pa_irs
rabic93817393rabi_c
rabid84520773rabi_d
rabies85226013rabies
saber75330243saber_
sabers85224733sabers
sabin74924943sabi_n
sabine84020383sabine
sabins85521973sabins
sabra75317853sab_ra
sabre74821503sab_re
satire63218003satire
seabird1055363seabird
tabard9313333tabard
taber73825823taber_
tabers84621573tabers
tabid84418253tabi_d
tabor75518393tabor_
tabors84517093tabors
tabour84011313tabour
tabu66328493tab__u
tapir75917063tapir_
tapirs84113173tapirs
vair75624143va_ir_
vairs85019133va_irs
wair75830053wa_ir_
wairs86424063wa_irs
yaird96111913ya_ird
zaire14311993za_ire

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127161567.61014811.6
3Display Results1561560.0463391.3
 (SQL Overall)1786911567.82922824.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.