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 “truffle” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

148 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
truffle138489(None) 
ruffle124111671_ruffle
truffe1276231truff_e
truffled1563991truffled
truffles1485591truffles
duffle13368532_duffle
gruffly17413892gruffly
muffle14339642_muffle
raffle123910702_raffle
riffle124210232_riffle
ruffe114713812_ruff_e
ruffled14369152_ruffled
ruffler13369722_ruffler
ruffles133512272_ruffles
ruffly15336672_ruffly
scuffle15266892scuffle
shuffle16276922shuffle
snuffle13267832snuffle
souffle13306802souffle
trifle94012882tr_ifle
truckle13358862truckle
truffes1356772truffes
trundle8307872trundle
baffle14399873_baffle
bluffly1833433bluffly
bouffe14438313bouff_e
coffle14359043_coffle
crumble133410403crumble
crumple13368363crumple
drumble12337893drumble
duffel13407753_duffel
duffles14308923_duffles
etouffee1462303etouffee
griffe13438093griff_e
gruff124712143gruff__
gruffed1544943gruffed
gruffer1475793gruffer
gruffier1544703gruffier
gruffily1863083gruffily
gruffs13337453gruff_s
gruffy16396013gruff_y
grumble12349233grumble
gruntle8257053gruntle
kerfuffle185773kerfuffle
muffled16377783_muffled
muffler15398343_muffler
muffles153910453_muffles
piffle14418233_piffle
pouffe14448263pouff_e
prefile123413183prefile
profile123211153profile
purfle112511183_purfle
raffled14429083_raffled
raffler13339223_raffler
raffles133611843_raffles
refile95122373_refile
riffled14338603_riffled
riffler13328353_riffler
riffles133911163_riffles
rifle85518333_r_ifle
rubble104315673_rubble
ruble74521253_ru_ble
ruckle124414583_ruckle
ruddle83414203_ruddle
ruff105127653_ruff__
ruffed134312743_ruffed
ruffes124112423_ruffes
rufflers14347193_rufflers
rufflier1434013_rufflier
rufflike1843253_rufflike
ruffs114516743_ruff_s
rule49938423_ru__le
rumble103718813_rumble
rumple103913013_rumple
rundle73214233_rundle
runkle103611543_runkle
rustle63615413_rustle
rutile65217683_rutile
scuffled17256203scuffled
scuffler16286703scuffler
scuffles16287863scuffles
shuffled18296243shuffled
shuffler17306803shuffler
shuffles17297783shuffles
skiffle17225203skiffle
snaffle13216253snaffle
sniffle13287653sniffle
snuffled15277033snuffled
snuffler14317413snuffler
snuffles14318413snuffles
snuffly16305203snuffly
souffled15276193souffled
souffles14298123souffles
struggle10345053struggle
tartuffe1461903tartuff_e
toffee123311013t_offee
tousle64514653tou_sle
touzle15429003tou_zle
trachle12311853trachle
traffic1544733traffic
trample11299703trample
trauchle1344963trauchle
treacle939973treacle
treadle8310103treadle
treble8311663tr_eble
treddle936433treddle
tremble1138003tremble
trestle72611363trestle
triable92515393triable
trickle133613443trickle
trifled113711963tr_ifled
trifler103912153tr_ifler
trifles103814823tr_ifles
trifold1136243trifold
trindle83311363trindle
triple84215923tr_iple
troffer13125863troffer
trouble957713trouble
truce75118693tru__ce
truckled15327313truckled
truckler14297453truckler
truckles14319383truckles
trudge8318733tru_dge
true46725853tru___e
trueblue1042163trueblue
trull54012673tru__ll
trulls64110283tru_lls
truly84111553tru__ly
trundled10306393trundled
trundler9256153trundler
trundles9278483trundles
trunnel745403trunnel
trustee73514443trustee
tubule839853t_ubule
tuff104528523t_uff__
tuffet122612083t_uffet
tuffs115118263t_uff_s
tufoli933973t_ufoli
tuille63012643t_uille
tule45735873t_u__le
tulle54019933t_u_lle
tumble103215643t_umble
turtle63213573t_urtle
tussle637143t_ussle
unmuffle1662343unmuffle
unruffled1672923unruffled
waffle15369183_waffle
whiffle1933533whiffle

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271485.84622926.3
3Display Results1481480.0632349.2
 (SQL Overall)1786911486.32928233.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.