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 “flintlike” 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
flintlike164312(None) 
finlike14279062f_in_like
linelike12159002_linelike
plantlike1544942plantlike
saintlike1344782saintlike
slitlike1235302sli_tlike
antlike11312073__antlike
auntlike1234983_auntlike
clifflike2141903clifflike
fairylike1942693fairylike
fanglike1636823f_anglike
fanlike142610503f_an_like
fatlike142911193f__atlike
faunlike1534763faun_like
fawnlike1844143fawn_like
feltlike1534983f_eltlike
fernlike1535243fern_like
filmlike1734443f_ilmlike
finalise113112573f_inalise
finalize202711023f_inalize
fishlike18225873f_ishlike
flamelike1845063flamelike
flatline11298923fl_atline
flinkite1543623flin_kite
flintier1136393flint_ier
flintily1434893flint_ily
flinting123412343flint_ing
flintlock1851483flintlock
flintlocks1951433flintlocks
fluidlike1742403fluidlike
flutelike1663583flutelike
footlike1537253f_ootlike
frontline1245053frontline
fruitlike1642853fruitlike
giantlike1443263giantlike
glenlike1334043glen_like
inklike1037033__inklike
kiltlike1134243_kiltlike
kinglike1235093_kinglike
lifelike15166223_lifelike
lilylike1543853_lilylike
lionlike1234983_lionlike
liplike1337283_li_plike
loftlike1534393_loftlike
pinelike14188613_pinelike
planetlike1643033planetlike
ringlike1336243_ringlike
skinlike1134873skin_like
skirtlike1243003skirtlike
spinelike1585353spinelike
suitlike1236313sui_tlike
tentlike1236903_tentlike
tinlike11248803_tin_like
veinlike1534313vein_like
winglike1635593_winglike

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641556.90621523.5
3Display Results55550.0163437.5
 (SQL Overall)178691557.34524328.3
 
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.