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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
preflame154591(None) 
preface14510922pref_ace
prefade1339012pref_ade
pregame1239552pre_game
prelate9519692pre_late
prename11412642pre_name
preplace1488982preplace
reclame11411062_reclame
reflate103516262_reflate
reframe1239392_reframe
aflame1138723__aflame
areolae7811733areola_e
areolate81014453areolate
defame123212433_def_ame
deflate113613943_deflate
enflame1236573_enflame
flame105124443___flame
inflame1256963_inflame
oriflamme1651353oriflamme
pelage9515363p_e_lage
penname11328553p_enname
perfume1446503perf_ume
preamp1238993pre__amp
prebade12310283pre_bade
prebake1539093pre_bake
preclude1344903preclude
predate10616893pre_date
prefab1336243pref_a_b
prefabs1435163pref_abs
prefaced1638423pref_aced
prefacer1537983pref_acer
prefaces15311063pref_aces
prefaded1537823pref_aded
prefades1439533pref_ades
prefile123413183pref_ile
prefire124012813pref_ire
preform1439613preform_
preformed17176203preformed
preforms1537403preforms
prefrank1764233prefrank
prefroze2264673prefroze
pregames1339003pre_games
prelacy1437583pre_lacy
prelates10418573pre_lates
prelaw1139103pre_la_w
prelife1279943pre_life
prelim10311423pre_lim_
prelims1139823pre_lims
prelude1038013pre_lude
premade12311443pre_made
prenames12311643pre_names
prepare111913623pre_pare
prepave14228873pre_pave
preplaced1676483preplaced
preplaces1578753preplaces
preplan1149953prepla_n
preplans1249613preplans
preplant12712913preplant
prerace11414123pre_race
presage10312293pre_sage
presale9416353pre_sale
preshape1537533preshape
preslice1258623preslice
prestamp1445323prestamp
presume11310303pre_sume
pretape113511623pre_tape
prevalue1345073prevalue
profane122111863prof_ane
prolate9419793pr_olate
reclames12310893_reclames
reface113616353_ref_ace
reflag1098083_refla_g
reflags1156953_reflags
reflated123514293_reflated
reflates113115663_reflates
reframed1437853_reframed
reframes1338993_reframes
reglaze1747223_reglaze
reinflame14133883_reinflame
relace83122153_re_lace
relate64033633_re_late
relume8313273_re_lume
rename82718813_re_name
replace113214283_replace
replate93420053_replate
reslate73520593_reslate

Search took 9 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.406440125.6
2DLD Change Limit146162867.78318779.6
3Display Results86860.0302866.7
 (SQL Overall)178691868.21921741.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.