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

120 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
kitbag133497(None) 
kitbags1443881kitbags
airbag956962airbag
dirtbag1143022dirtbag
kiting114117092kiting
ratbag956562ratbag
airbags1036293airbags
bag67059223___bag
biting95321823biting
bitmap1235613bitmap
citing94220183citing
citral81113883citral
debag94212303_debag
dirtbags1242703dirtbags
disbar938513disbar
dita56032523dit_a_
ditas65923673dit_as
footbag1344543footbag
gasbag1035413gasbag
gimbal11228803gimbal
hitman112710213hitman
isba61310873_isba_
isbas71010393_isbas
jetlag1434523jetlag
kabab134814433k_abab
kabar114815553k_abar
kanban1238623kanban
kasbah1535183kasbah
kata85626023kat_a_
katas95922093kat_as
kbar106514653k__bar
kebab134311993k_ebab
kebar115113533k_ebar
kiang104811353ki_ang
kibbe135211963ki_bbe
kibbeh17406063kibbeh
kibbes143811193kibbes
kibbi13449263ki_bbi
kibbis14398463kibbis
kibble143910953kibble
kibe106523433ki_b_e
kibei114311533ki_bei
kibes115521113ki_bes
kibla1139833ki_bla
kiblah1535583kiblah
kiblas1239323kiblas
kidnap1334193kidnap
kilobar1344613kilobar
kilting123213853kilting
kina85631993ki_na_
kinas95626913ki_nas
king95933653ki__ng
kismat123011673kismat
kit78559873kit___
kite85338233kit__e
kited105120093kit_ed
kiter95523213kit_er
kiters105218583kiters
kites95432543kit_es
kith115826353kit__h
kithara14145193kithara
kithe125917453kit_he
kithed144613013kithed
kithes135016653kithes
kithing153411553kithing
kiths125814973kit_hs
kitling123313573kitling
kits86441763kit__s
kitsch1533353kitsch
kitted115114833kitted
kittel10368863kittel
kitten104611483kitten
kitting123214443kitting
kittle104012173kittle
kitty124614563kit_ty
kiva116516403ki_va_
kivas124614733ki_vas
limba95414973limba_
limbas105313193limbas
litai55216363lit_ai
litas54923773lit_as
mailbag1243923mailbag
mimbar1297483mimbar
mitral81314323mitral
outbeg938733outbeg
outbrag1036993outbrag
pibal95217323pi_bal
pita65436433pit_a_
pitas77427673pit_as
pitman102412123pitman
pitsaw1135613pitsaw
pitta75018693pitta_
pittas86014523pittas
postbag1245223postbag
ragbag1045463ragbag
ratbags1035763ratbags
retag63618413ret_ag
ritual6310613ritual
seabag938473seabag
sitar54820543sit_ar
siting74126623siting
skiting123812493skiting
stag57332003_st_ag
tag47259493__t_ag
timbal102510743timbal
titan53318173tit_an
titbit839813titbit
titian62512663titian
titman82710993titman
vita75828523vit_a_
vitae84217633vit_ae
vital84819673vit_al
vitta85015173vitta_
vittae93910993vittae
wigwag1443723wigwag
windbag1444123windbag
witan83816503wit_an
withal1238933withal
witing103522823witing
zigzag1642963zigzag

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161206.08018538.8
3Display Results1201200.0304000.0
 (SQL Overall)1786911206.25028590.6
 
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.