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

105 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
retrospection178431(None) 
retrospections1894171retrospections
introspection1764622introspection
retroflection1854042retroflection
retrospecting1863452retrospecting
retrospective2083512retrospective
introspections1864063introspections
reinspection1653263re_inspection
retroaction1347363retro__action
retrodiction1555653retro_diction
retroflections1953873retroflections
retrospect1463833retrospect___
retrospected1752663retrospect_ed
retrospectives2192783retrospectives
retrospects1562903retrospect__s
introjection2156204intro_jection
introspecting18123574introspecting
introspectional1972634introspectional
introspective2073574introspective
recollection1654854re_collection
reconnection1655994re_connection
reinspections1753094re_inspections
reproduction1765654repro_duction
resection111613274re___s_ection
retraction121310534retr___action
retroactions1447074retro__actions
retrocession1494454retro_cession
retrodictions1655534retro_dictions
retroflexion2262074retrofle_xion
retrogression14103424retrogression
retroreflection20111674retroreflection
retrospectively2572174retrospectively
retroversion1573674retro_version
trisection1245984__tris_ection
detection121310415det____ection
detraction13138585detr___action
erection102115515_e_r___ection
exsection1847495_e__xs_ection
inspection1446665___inspection
intersection14610185inters_ection
introduction1555785intro_duction
introjections2255785intro_jections
introspect1474385introspect___
introspected1752845introspect_ed
introspects15103035introspect__s
neurosecretion1671525neuros_ecretion
perfection1748365pe_r__fection
persecution1564785pe_r_s_ecution
perspective2054865pe_r_spective
petrifaction1953725petr_ifaction
preproduction2054395prepro_duction
projection2158765__pro_jection
prosecution1546075__pros_ecution
prospecting1845855__prospecting
prospective2055405__prospective
prospector1644365__prospect_or
protection14511475__pro_tection
reassertion1154025re__assertion
recollections1754725re_collections
reconception1855645re_conception
reconnections1765755re_connections
reconviction1955085re_conviction
recreation12413615recr___eation
redirection1446055re__direction
reelection12198635re___election
refection141512285re____fection
reflection15168995re___flection
refraction15137905refr___action
reinfection1645445re__infection
reinjection2044585re__injection
reinsertion1145445re_ins_ertion
reinspecting1763205re_inspecting
reintroduction1762375reintro_duction
rejection181710255re____jection
reoperation13410905re__o_peration
reposition121010145re_pos__ition
repossession1453095re_possession
reprobation1548505repro__bation
reproductions1865275repro_ductions
resections121513035re___s_ections
resorption1247255re_sorp__tion
respecting1549885re___specting
respective1747625re___spective
restriction1349365restr___iction
resurrection1453355re_surrection
retention91611485ret____ention
retorsion946505retors____ion
retortion949675ret_o___rtion
retractions13910355retr___actions
retranslation1354685retranslation
retribution13114985retr__ibution
retroacting1447285retro__acting
retroactive1645825retro__active
retrocessions15114355retro_cessions
retrodicting1654465retro_dicting
retrodictive1853875retro_dictive
retroflexions2362045retrofle_xions
retrogradation16151885retrogradation
retrogressions15113165retrogressions
retroversions1673455retro_versions
trajection1944695__tr_ajection
transection1357375__transection
transfection1765395__transfection
trisections1345645__tris_ections
venesection1652945ve_nes_ection

Search took 10 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.390458182.1
2DLD Change Limit1247901058.90614011.9
3Display Results1051050.0761381.6
 (SQL Overall)1786911059.37219066.5
 
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.