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

54 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
kipskin124347(None) 
kidskin1143831kidskin
kipskins1343261kipskins
kidskins1243452kidskins
oilskin1144472oilskin
pigskin1444352pigskin
pipkin14248602pip_kin
siskin1079782si_skin
buskin123811493_buskin
capeskin1644403capeskin
cipolin1148783cipolin
cowskin1645553cowskin
dipshit1348003dipshit
disking134615493di_sking
doeskin1245153doeskin
finikin14266863finikin
firkin1337823fi_rkin
foxskin2143133foxskin
gaskin113610583_gaskin
gipsying1533373gipsying
griskin1236013griskin
kamsin1238323kams_in
kicking133314023ki_cking
kinetin11248263kinetin
kingpin1445003kingpin
kinin94917333ki__nin
kinking113615153ki_nking
kinship1645833kinship
kinsman1335963kinsman
kinsmen1335653kinsmen
kiosk836243kiosk__
kiosks934383kiosk_s
kippen14299013kip_pen
kipping163311873kip_ping
kips106430533kips___
kissing122911053ki_ssing
limpkin1534223limpkin
lipin75518893lip__in
minikin13258983minikin
napkin1236903nap_kin
oilskins1243873oilskins
opsin7613473_ops_in
pekin111514423__pekin
pepsin10310853peps_in
pigskins1544253pigskins
pipkins15328183pip_kins
pippin92810303pip_pin
redskin1286023redskin
ripsawn1242503ripsawn
risking123914243ri_sking
siskins1159583si_skins
skin85927543___skin
topspin1145113topspin
wineskin1544243wineskin

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 Limit134027545.73623365.9
3Display Results54540.0134153.8
 (SQL Overall)178691546.15529031.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.