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

100 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
teffs11511173(None) 
effs105114031_effs
teff106023761teff_
tiffs114414881tiffs
toffs116016721toffs
tuffs115118261tuffs
baffs134718052baffs
beefs105618562beefs
biffs134814412biffs
boffs134915502boffs
buffs135519512buffs
caffs135417372caffs
coffs134916302coffs
cuffs135017492cuffs
daffs125116422daffs
defis96717502defis
delfs94918672delfs
diffs126315482diffs
doffs125614332doffs
duffs125216622duffs
eff96128622_eff_
efs66829602_e_fs
efts76519482_efts
feoffs1163702feoffs
gaffs124914652gaffs
guffs124414822guffs
hefts116218152hefts
huffs144514742huffs
jefes155613672jefes
jiffs185710312jiffs
keefs125116282keefs
kefs115922742ke_fs
kerfs125413572kerfs
leafs85721182leafs
lefts86517812lefts
luffs114516282luffs
miffs134512882miffs
muffs134114212muffs
naffs116213962naffs
neifs85613042neifs
offs107117012_offs
pelfs105016292pelfs
puffs134114932puffs
raffs115017522raffs
reefs85121662reefs
refs75732242re_fs
reifs84819092reifs
riffs115114612riffs
ruffs114516742ruffs
seifs85019332seifs
selfs85220242selfs
serfs84922012serfs
staffs12349752staffs
stiffs12389962stiffs
stuffs123810222stuffs
taffy145110822taffy
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492te_as
teats55636812teats
techs106915832techs
teds54932572te_ds
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582te_es
teggs74710742teggs
tegs56031492te_gs
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692te_ls
temps95417132temps
tends65425582tends
tens45647412te_ns
tents56434212tents
tepas76521682tepas
terms75523472terms
terns55226872terns
tests56530192tests
teths85418512teths
tets45847462te_ts
tews76431642te_ws
texas126514932texas
texts125515042texts
thefts12387922thefts
tiff104727722tiff_
toff105929902toff_
toffy145310282toffy
tofts84919242tofts
tofus86415422tofus
tufas85314382tufas
tuff104528522tuff_
tufts85713272tufts
turfs84620442turfs
waffs146315472waffs
wefts116715492wefts
yaffs145311122yaffs

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.313570897.8
2DLD Change Limit538001001.53035163.4
3Display Results1001000.0303333.3
 (SQL Overall)1786911001.87395403.6
 
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.