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

70 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
guilt6512557(None) 
built74325921built
gilt56348541g_ilt
guild75312751guild
guile64521131guile
guilts74111231guilts
guilty10418231guilty
quilt144125101quilt
atilt54828472atilt
build84413352build
cult66541152cu_lt
duit56241582dui_t
gaily95020972gaily
gait56150192gai_t
gault65128482gault
gelt56448012g_elt
gift86735792g_ift
gild65526512g_ild
gill56336182g_ill
gilts64924262g_ilts
girt56646422g_irt
gist56046762g_ist
git46266052g_i_t
glint66830182glint
gluily10308292gluily
grift95924462grift
grill64617892grill
griot65328412griot
gript85126172gript
grist65529872grist
grit55247242gri_t
guest65225922guest
guglet84018222guglet
guid66022822gui_d
guide75019882guide
guids75516152guids
guilds8388352guilds
guiled84315382guiled
guiles73919282guiles
guiro63712092guiro
guise64717712guise
gul45832792gu_l_
gulf84929422gu_lf
gull54828452gu_ll
gullet74924832gullet
gulls65222982gulls
gully94020682gully
gulp75521362gu_lp
guls55930852gu_ls
gust55240702gu_st
gut46753852gu__t
guyot9314522guyot
hilt75850712_hilt
jilt115839422_jilt
kilt86144422_kilt
lilt46349942_lilt
milt65455812_milt
quiet144530732quiet
quill148413772quill
quilts154112542quilts
quint144529902quint
quirt144624232quirt
quit136136512qui_t
silt46558192_silt
spilt75532222spilt
stilt54831982stilt
suint55638182suint
suit45649872sui_t
tilt46252422_tilt
wilt76246292_wilt

Search took 4 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.610292936.1
2DLD Change Limit53800703.06317564.5
3Display Results70700.0431627.9
 (SQL Overall)178691703.71648086.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.