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

153 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
katcina134515(None) 
katchina1745331katchina
katcinas1434511katcinas
kachina1637662kachina
katchinas1843922katchinas
latina65621142lat_ina
patina86022192pat_ina
sarcina9310732sarcina
vaccina1435302vaccina
acinar8310483_a_cinar
acing87429153_a_cing
acini75718983_a_cini
actin74922553_actin_
actinal9312293_actinal
acting95920983_acting
actinia91710853_actinia
actins86321103_actins
aecia73819283_aeci_a
angina7413133_angina
arcana8912583_arcana
arcing95819643_arcing
atonia63816513_atonia
atria56022343_atri_a
batching163712093batching
bathing134816243bathing
bating95132253bat_ing
batting104422273batting
batwing13509813batwing
calcine11315273calcine
cantina93417253cantina
carina84325333ca_rina
cassina94113163cassina
catching163712773catching
catena8312483cat_ena
catkin123512383catkin_
catkins133012563catkins
catlin83819083catlin_
catling104819793catling
catlins93818843catlins
catmint11314463catmint
catting103922643catting
dancing113611563dancing
datcha1266563datc_ha
dating85326483dat_ing
eating75134403eat_ing
encina8310443_encina
facia103218463fa_ci_a
facing125321573fa_cing
farcing133514003farcing
farina94618233fa_rina
fascia1148703fasci_a
fascine12510583fascine
fating105328673fat_ing
fatling113815683fatling
fatting113818703fatting
gating84826953gat_ing
hatching173312213hatching
hating104929713hat_ing
hatpin112610613hatpin_
hatpins123410643hatpins
hatting113920233hatting
jacana1537933ja_cana
jarina134014063ja_rina
kachinas1736343kachinas
kahuna1394103ka_huna
kain85334293ka__in_
kains96125643ka__ins
kalian10312163ka_lian
kalmia1238893kalmi_a
kamaaina1443273kamaaina
kamsin1238323kamsin_
kamsins1346963kamsins
kana85928533ka___na
kaolin1039583kaolin_
kaoline11310143kaoline
kaolins1139363kaolins
karting123716063karting
kata85626023kat___a
katakana1142433katakana
kation104315683kat_ion
kations114013663kations
katsura1143753katsura
kayoing1535403kayoing
kina85632003k___ina
kithing153411553kithing
kiting114117093kit_ing
kitling123313573kitling
kitting123214443kitting
kything18285523kything
lacing94626233la_cing
lacuna8118123la_cuna
lamina84920443la_mina
lancing103314123lancing
latching143712023latching
lathing114315693lathing
latinas74416463lat_inas
latino64120473lat_ino
latria62313603latri_a
latrine7715133latrine
lattin64316223lattin_
lattins74115483lattins
macing114221553ma_cing
marina84623413ma_rina
matching163512393matching
matin75132853mat_in_
matinal9312603mat_inal
mating94832913mat_ing
matins84527783mat_ins
mattin84416633mattin_
matting103620143matting
mattins93316143mattins
nandina838913nandina
pacing114522753pa_cing
pastina93914593pastina
patching163212753patching
patin76832853pat_in_
patinae95414403pat_inae
patinas96318523pat_inas
patine85328123pat_ine
patins87528783pat_ins
patting103722343patting
piscina1177043piscina
platina94413643plat_ina
racing95030533ra_cing
ratfink1434943ratfink
ratine65131823rat_ine
rating74938703rat_ing
ratlin64116523ratlin_
ratline74517803ratline
ratlins73615583ratlins
ratting83822363ratting
retina65023383ret_ina
retsina74710603retsina
salina64221123sa_lina
sarcinae1047193sarcinae
sarcinas1039283sarcinas
satin55935223sat_in_
sating74735453sat_ing
satins64930483sat_ins
satiny93817983sat_iny
saucing10311003saucing
skating123613853skat_ing
stamina9310793stamina
talcing103111633talcing
tatting84019523tatting
vaccinal1544903vaccinal
vaccinas1544973vaccinas
vaccine1437323vaccine
vaccinia1543363vaccinia
vagina102710933va_gina
vaticinal1444573vaticinal
vatting113614853vatting
watching173011173watching

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271536.45320769.7
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.92225814.9
 
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.