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

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

123 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
retroflection185404(None) 
retroflections1953871retroflections
retroflexion2262062retrofle_xion
retroreflection20111672retroreflection
retrospection1784312retrospection
recollection1654853re_collection
reflection15168993re___flection
retroaction1347363retro__action
retrodiction1555653retro_diction
retroflexions2362043retrofle_xions
retrospections1894173retrospections
antireflection19102414antireflection
deflection16147734de___flection
genuflection1851614ge_nuflection
introjection2156204intro_jection
introspection1764624introspection
perfection1748364pe_r_f_ection
petrifaction1953724petrif_action
recollections1754724re_collections
reconnection1655994re_connection
reelection12198634re___election
refection141512284re___f_ection
reflections16178554re___flections
reinfection1645444re_inf_ection
reproduction1765654repro_duction
retraction121310534retr___action
retroactions1447074retro__actions
retrocession1494454retro_cession
retrodictions1655534retro_dictions
retrogression14103424retrogression
retroreflective2371304retroreflective
retroreflector1971124retroreflect_or
retrospecting1863454retrospecting
retrospective2083514retrospective
retroversion1573674retro_version
bolection13117675___bo_lection
collection1448205___collection
defection151610645de___f_ection
deflections17187325de___flections
dereliction1444575de_r_eliction
detection121310415det____ection
detraction13138585detr___action
election102015355_e____lection
erection102115515_e_r___ection
etiolation1048535_etio_l_ation
flection13239565_____flection
genuflections1951515ge_nuflections
inflection1547635___inflection
intellection1466165int_ellection
introduction1555785intro_duction
introjections2255785intro_jections
introspections1864065introspections
metafiction1852845met_af_iction
perfections1848145pe_r_f_ections
petrifactions2083565petrif_actions
petrification2048815petrification
predilection1754105pre__dilection
preelection15136485__preelection
prelection141511295__pr_election
preproduction2054395prepro_duction
preselection16154885pre__selection
projection2158765__pro_jection
protection14511475__pro_tection
putrefaction1952465putref_action
rarefaction1652655r_aref_action
recollecting1764085re_collecting
reconception1855645re_conception
reconnections1765755re_connections
reconviction1955085re_conviction
recreation12413615recr___eation
redirection1446055re__direction
reelections13167945re___elections
refections151811645re___f_ections
reflation12412335re___fl_ation
reflecting1638825re___flecting
reflectional1753995re___flectional
reflective1857125re___flective
reflector1445735re___flect_or
reflexion1943615re___fle_xion
refraction15137905re___fraction
reinfections1745325re_inf_ections
reinflation1447205re_infl_ation
reinjection2044585re__injection
reinspection1653265re_inspection
reintroduction1762375reintro_duction
rejection181710255re____jection
reliction11310695re____liction
repletion1147695re___ple_tion
reprobation1548505repro__bation
reproductions1865275repro_ductions
resection111613275re____section
resolution1097735re_so_l_ution
restriction1349365restr___iction
resurrection1453355re_surrection
retaliation11612325ret__aliation
retention91611485ret____ention
reticulation1448055reticul_ation
retortion949675ret_o___rtion
retractions13910355retr___actions
retranslation1354685retranslation
retribution13114985retr__ibution
retroacting1447285retro__acting
retroactive1645825retro__active
retrocessions15114355retro_cessions
retrodicting1654465retro_dicting
retrodictive1853875retro_dictive
retrofitting1653185retrof_itting
retroflex1942925retrofle____x
retroflexes2151945retrofle__xes
retrogradation16151885retrogradation
retrogressions15113165retrogressions
retroreflectors2071025retroreflectors
retrospect1463835retrospect___
retrospected1752665retrospect_ed
retrospectives2192785retrospectives
retrospects1562905retrospect__s
retroversions1673455retro_versions
revolution13117565re_vo_l_ution
selection11311275se____lection
subcollection1961715subcollection
trajection1944695__tr_ajection
transection1357375__transection
trisection1245985__tr_isection

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 Filter1786911247900.393454684.5
2DLD Change Limit1247901238.37314903.9
3Display Results1231230.0761618.4
 (SQL Overall)1786911238.84220209.3
 
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.