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

78 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
croft10562268(None) 
coft97939681c_oft
craft105327661craft
crofts114910591crofts
aloft8423432aloft
chott103923932chott
cleft106222852cleft
clift106422192clift
cloot76127052cloot
clot66542422clo_t
clout75330462clout
coat67558352c_oat
coff126930782c_off
colt67158242c_olt
coof96643272coof_
coofs105924712coofs
coopt95929852coopt
coot67860382c_oot
corf95941482corf_
cost68057942c_ost
cot510483222c_o_t
crafts115312742crafts
crafty14478912crafty
crept95125892crept
crest74632692crest
crit65743712cr_it
croak115216632croak
croc85723732cro_c
croci95818132croci
crock135921992crock
crocs95722432crocs
crofter12299572crofter
crone75231332crone
crony105918672crony
crook115217572crook
croon75522782croon
crop87628632cro_p
crops96125242crops
crore74922872crore
cross75124502cross
croup95616782croup
croute84617272croute
crow96428132cro_w
crowd115815622crowd
crown105620082crown
crows105727312crows
croze164719452croze
cruet74831842cruet
crust75827662crust
crypt123715232crypt
draft95526682draft
drift95722842drift
droit65127122droit
dropt86924432dropt
front85029222front
frost84727832frost
graft95327202graft
grift95924462grift
groat65531972groat
grot55942052gro_t
grout65330422grout
kraft125721012kraft
loft76539142_loft
oft67744062__oft
prof96134662prof_
profit113016272profit
profs105120892profs
prost75434102prost
raft76245912_raft
reft75141272_reft
rift75642342_rift
root45655922_root
rot37282952_ro_t
rout46153282_rout
soft76942822_soft
toft77441652_toft
trot46351312tro_t
trout57332572trout

Search took 7 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 Filter178691538001.013176397.8
2DLD Change Limit53800785.4709835.5
3Display Results78780.0461695.7
 (SQL Overall)178691786.52927368.8
 
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.