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

113 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
figeater123695(None) 
figeaters1345751figeaters
digester10258432digester
feater95224052f__eater
fidgeter1343782fidge_ter
fighter143010772fig_hter
firewater1545212firewater
anteater8311603anteater
beater84729393__beater
begetter11136313begetter
bilgewater1671933bilgewater
bimester1236163bimester
bleater94515303_bleater
cheater124816963_cheater
ciguatera1241873ciguatera
defeater122611663defeater
diester83013683di_ester
dieter73516773di_e_ter
digested11208163digested
digesters11257883digesters
digestor10246553digestor
dilater83515653di_later
dimeter10411893dime_ter
directer1137583directer
diverter12238623diverter
eater54639843___eater
eggbeater1341783eggbeater
fagoter1135883fag_oter
fearer94820183f__earer
feaster10812983f__easter
feather133613503f__eather
fester94723513f__ester
fetter94120383f__etter
fibster12146533fi_bster
fidgeted1443893fidge_ted
fidgeters1443623fidge_ters
fielder11217413fi_elder
fiercer12356953fi_ercer
fierier103511193fi_erier
fighters15269403fig_hters
figurate1237193figurate_
figurer11215863fig_urer
fileted1159093file_ted
filiate10414233filiate_
filiated12610083filiated
filiates11412663filiates
filister1137403filister
filter94517633fi__lter
fingerer12127223finge_rer
firewaters1644323firewaters
fissate103010033fissate_
fitter94120033fi__tter
fixate1638733fi_xate_
fixated1835533fi_xated
fixates1737393fi_xates
fleeter103210363f_leeter
floater104413353f_loater
fomenter1339263fomenter
forester11313673forester
forgetter1345373forgetter
foveate1338363foveate_
foveated1536293foveated
frater94520593f__rater
fretter103412753f_retter
frigate11311063frig_ate_
frigates12310933frig_ates
gater64533653__g_ater
getter74117613__getter
grater74625443__grater
greater84416493_greater
heater94828303__heater
ideate7313683_ideate_
ideated9310973_ideated
ideates8313733_ideates
igniter8147673_igniter
irater65218353_i_rater
kiester11329973ki_ester
ligate72519253lig_ate_
ligated92414143lig_ated
ligates82318383lig_ates
lighter113113443lig_hter
limewater1444073limewater
lineate7815153lineate_
lineated9711063lineated
migrate101314173migrate_
migrated121110513migrated
migrates111112853migrates
migrator1147873migrator
miseaten10310773miseaten
misenter10310833misenter
neater64424313__neater
negater83711963neg_ater
pileate93815923pileate_
pileated112711133pileated
pleater93916333_pleater
reheater113413033reheater
repeater102615443repeater
righter113212383rig_hter
rimester1037813rimester
riveter10208753rive_ter
seater64534163__seater
sighter113412113sig_hter
sigmate10710143sigmate_
signaler945453signaler
silenter838873silenter
sweater103712723_sweater
theater104014253_theater
tidewater1344123tidewater
tighter112910693tig_hter
treater74219833_treater
vignetter1343323vignetter
violater1137253violater
wigmaker1843803wigmaker

Search took 8 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 Filter1786911461620.403443402.0
2DLD Change Limit1461621136.59622159.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.04525364.2
 
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.