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

55 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
epiclike164414(None) 
piglike14157312_piglike
airlike11310333_airlike
apelike13310533ap_elike
biblike1536893_biblike
bricklike1643113bricklike
disclike15208653disclike
dislike122913453_dislike
eellike1138233e_ellike
elflike1435133e_lflike
epicene1148593epic_ene
epicure1136823epic_ure
epicycle1743393epicycle
epilate9314283epi_late
epizoite1944143epizoite
eyelike1436973e_yelike
finlike14279063_finlike
hairlike1536673hairlike
helicline1444693helicline
hiplike1637603_hiplike
icelike1337173__icelike
jiglike19105333_jiglike
kidlike1137063_kidlike
liplike1337283_liplike
mislike132914833_mislike
niblike1336703_niblike
peaklike13115373peaklike
pealike131211273_pealike
peglike14136773_peglike
picoline12310853_picoline
picrite111911313_picrite
pinelike14188613_pinelike
pipelike16166693_pipelike
podlike14108553_podlike
potlike13910123_potlike
puslike1347563_puslike
resinlike1344363resinlike
riblike1337333_riblike
saclike131210123_saclike
sepiolite1146803sepiolite
skinlike1134873skinlike
slitlike1235303slitlike
sparlike1437673sparlike
spikelike14103873spikelike
spinelike1585353spinelike
sticklike1444003sticklike
suitlike1236313suitlike
taillike1237863taillike
tinlike11248803_tinlike
twiglike1642793twiglike
veillike1534603veillike
veinlike1534313veinlike
waiflike1834573waiflike
whiplike2043813whiplike
wiglike15125853_wiglike

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.470380193.6
2DLD Change Limit146162558.11018022.4
3Display Results55550.0301833.3
 (SQL Overall)178691558.61020753.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.