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

73 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
killicks135487(None) 
killick1295311killick_
killocks1354791killocks
hillocks1736062hillocks
killies113318112killi_es
killings133710482killings
killock1255252killock_
klicks11468722k__licks
niblicks1643762niblicks
rollicks1444892rollicks
billies93923503billi_es
billings113412633billings
billions102211793billions
bollocks1636503bollocks
bullocks1636293bullocks
cilices113814023ci_lices
clicks145315113__clicks
cowlicks1944663cowlicks
dillies84122163dilli_es
fillies103420253filli_es
fillings122910503fillings
fillips12298133filli_ps
flicks154512993__flicks
gallicas1136933gallicas
gillies84120963gilli_es
gimmicks1942473gimmicks
hillock1646693hillock_
hillocky2053403hillocky
illicit949833_illicit
illites72415013_illites
jillions15178283jillions
kellies113516853kelli_es
kicks104420093k___icks
kidlike1137063kidli_ke
kilims1277903ki_li_ms
killdees1373963killdees
killers114215583kill_ers
killie104114893killi__e
killifish1942673killifish
killing123118723killi_ng
killjoys2242033killjoys
kills94526183kill___s
kilties113014143kilti_es
kiltings13327083kiltings
kiltlike1134243kiltli_ke
kitlings13318103kitlings
klick105311443k__lick_
kliks8398833k__li_ks
licks115325393___licks
milliers102611903milliers
millimes122411373millimes
millines102718063millines
millings113712583millings
millions101712433millions
miskicks1544763miskicks
mullocks1645033mullocks
niblick1544453niblick_
nitpicks1643183nitpicks
pillions101610923pillions
pollacks1656373pollacks
pollices12410753pollices
pollocks1656473pollocks
rollick1335613rollick_
rollicky1742693rollicky
silicas9310603si_licas
sillies73425083silli_es
silvics1235563silvic_s
skillings14246133skillings
skinflicks186973skinflicks
slicks124816113__slicks
tillites8312833tillites
willies103920153willi_es
zillions17168073zillions

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit146162737.59319249.6
3Display Results73730.0332212.1
 (SQL Overall)178691738.04622208.7
 
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.