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

68 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
clift10642219(None) 
cleft106222851cleft
cliff135917131cliff
clifts11519151clifts
clipt96324271clipt
lift76942721_lift
alif76242142alif_
alifs86121262alifs
alist56136782alist
alit46155692ali_t
aloft8423432aloft
calif104929102calif_
califs114915892califs
chit96937462chi_t
cist67244962c_ist
clapt98027172clapt
clast76030582clast
cleat76335062cleat
clef97028182clef_
clefs106616242clefs
clefts114610162clefts
clept95725772clept
click135217952click
client8316342client
cliffs14477592cliffs
cliffy17435242cliffy
climb115413592climb
clime95720892clime
cline76428532cline
cling86424672cling
clink115320042clink
clip86924002cli_p
clips96018302clips
cloot76127052cloot
clot66542422cl_ot
clout75330462clout
coft97939682c_oft
coif96337912coif_
coifs105718702coifs
craft105327662craft
crit65743712cri_t
croft105622682croft
cuif96529142cuif_
cuifs104814692cuifs
drift95722842drift
elint55436472elint
flint87333502flint
flirt87424752flirt
flit76539272fli_t
gift86735792_gift
gliff124915662gliff
glint66830182glint
grift95924462grift
left76340482_left
life75433732_life
lifts85719062_lifts
lilt46349942_lilt
lint416266232_lint
list47055342_list
lit39377312_li_t
loft76539142_loft
rift75642332_rift
shift114225142shift
sift710740662_sift
slipt76627482slipt
slit46250102sli_t
swift116818052swift
uplift114610652uplift

Search took 2 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 Filter178691538000.293609866.9
2DLD Change Limit53800681.61033416.1
3Display Results68680.0164250.0
 (SQL Overall)178691681.91993116.7
 
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.