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 “kishkas” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
kishkas134348(None) 
kishka1232961kishka_
kishkes1334771kishkes
kashas133311902kash_as
kishke1254272kishk_e
bishops1437033bishops
bisks115416803bis_k_s
bushwas15105613bushwas
dishes104622653dish_es
dishpan13105523dishpan
dishpans14115833dishpans
dishrag1246273dishrag
dishrags1346203dishrags
disks105417473dis_k_s
fishers134714723fishers
fishes125221343fish_es
fishway1943813fishway
fishways2043643fishways
geishas1135073geish_as
isbas71010403_is_bas
kabakas12367403kabakas
kakas85117343k__akas
kanakas10327213kanakas
kasha124710723kash_a_
kashers143914023kashers
kiblas1239323ki_blas
kicks104420083ki_ck_s
kikes85122553ki__kes
kinaras1159123kinaras
kinas95626913ki__nas
kinemas1336893kinemas
kinks84926083ki_nk_s
kinships1745793kinships
kiosks934383kiosk_s
kirks84915263ki_rk_s
kismat123011673kis_mat
kismats13257843kismats
kismets13306883kismets
kiss85227393kis___s
kissers114211293kissers
kisses104217333kis_ses
kists95822113kis__ts
kitharas15165413kitharas
kithes135016653kith_es
kiths125814973kith__s
kivas124614733ki__vas
knishes1438263knish_es
koshers144811803koshers
lashkar1443703lashkar
lashkars1543673lashkars
lithias1038823lithias
misbias1139083misbias
mishap1338863mish_ap
mishaps1438713mishaps
mishear1238393mishear
mishears1338323mishears
mishits122513083mishits
mishmash18133433mishmash
miskal123710263mis_kal
miskals13369763mis_kals
orishas1036473orish_as
pashas115117063pash_as
pikas114218093pi__kas
pishers123815753pishers
pishes114722103pish_es
rikishas1542543rikish_as
rishis9312453rish_is
risks94917063ris_k_s
ristras7311563ristras
sheas86331793__sheas
shwas116415103__shwas
sifakas1443333sifakas
sikas94617023__sikas
skas85325713__s_kas
tikkas934523ti_kkas
visas84317653vis__as
vistas94513273vis_tas
wisha114910853wish_a_
wishers133215213wishers
wishes124920953wish_es

Search took 10 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.1561145455.1
2DLD Change Limit134027809.36014319.1
3Display Results80800.0332424.2
 (SQL Overall)178691809.54918713.1
 
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.