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

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

84 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
inkier10401377(None) 
dinkier123411501dinkier
hinkier143610791hinkier
ickier12439911ickier
inker94421091ink_er
inlier63615351inlier
kinkier10319431kinkier
cakier123115242cakier
chinkier17377362chinkier
dickier143512452dickier
dingier93513662dingier
dinkies123716032dinkies
envier939672envier
finnier10319942finnier
funkier14349982funkier
ginnier8298972ginnier
gunkier12369552gunkier
hokier134214032hokier
hunkier144512142hunkier
icier74313742i_cier
icker114018442ick_er
iffier1236752iffier
inaner62213532inaner
incher114114032incher
inciter93113772inciter
indie63721462indie_
indies73822772indies
inditer83514232inditer
infer84215032in_fer
inked104218522ink_ed
inkers104018832ink_ers
inkiest113415042inkiest
inking115119042inking
inkjet1737452inkjet
inkle94515832inkle_
inkles103515652inkles
inliers73110742inliers
inner54920622in_ner
insider849732insider
inter55028492in_ter
inviter104112312inviter
jinker174013542jink_er
jokier17618752jokier
junkier18339492junkier
kickier12349052kickier
kier86526802__kier
lakier104716272lakier
lankier113711632lankier
lingier84113372lingier
linier64423782lin_ier
linker104321462link_er
lintier73613792lintier
milkier133411162milkier
mincier113512462mincier
mingier103815282mingier
mintier93615992mintier
mirkier13319052mirkier
oakier104011392oakier
pickier153912972pickier
pinier84024692pin_ier
pinker125322442pink_er
pinkie124414272pinkie_
pinkies133818262pinkies
pokier124914632pokier
punkier133512792punkier
riskier1138422riskier
silkier114411642silkier
sinker103620902sink_er
skier95119592_skier
slinkier12206932slinkier
snakier112810002snakier
stinkier12278542stinkier
tinier63622232tin_ier
tinker103619922tink_er
tinkler113610542tinkler
tinklier1255442tinklier
tinnier72910132tinnier
vinier93716742vin_ier
windier113412162windier
wingier113413272wingier
winier94522452win_ier
winker134220292wink_er
wonkier1437422wonkier
zingier17369482zingier

Search took 6 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 Filter178691825510.313570897.8
2DLD Change Limit82551844.89016881.6
3Display Results84840.0332545.5
 (SQL Overall)178691845.23634127.4
 
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.