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

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

99 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
retrospections189417(None) 
retrospection1784311retrospection_
introspections1864062introspections
retroflections1953872retroflections
retrospecting1863452retrospecti_ng
retrospectives2192792retrospectives
introspection1764623introspection_
reinspections1753103re_inspections
retroactions1447073retro__actions
retrodictions1655533retro_dictions
retroflection1854043retroflection_
retrospective2083513retrospecti_ve
retrospects1562903retrospect___s
introjections2255784intro_jections
introspecting18123574introspecti_ng
introspectional1972634introspectional
recollections1754724re_collections
reconnections1765754re_connections
reinspection1653264re_inspection_
reproductions1865274repro_ductions
resections121513034re___s_ections
retractions13910354retr___actions
retroaction1347364retro__action_
retrocessions15114354retro_cessions
retrodiction1555654retro_diction_
retroflexions2362044retrofle_xions
retrogressions15113164retrogressions
retrospect1463834retrospect____
retrospected1752664retrospect__ed
retrospectively2572174retrospectively
retroversions1673454retro_versions
trisections1345644__tris_ections
detections131410045det____ections
detractions14118275detr___actions
erections112515215_e_r___ections
exsections1947635_e__xs_ections
inspections1546435___inspections
intersections1598965inters_ections
introductions1655135intro_ductions
introjection2156205intro_jection_
introspective2073575introspecti_ve
introspects15103035introspect___s
neurosecretions1771405neuros_ecretions
perfections1848145pe_r__fections
persecutions1654795pe_r_s_ecutions
perspectives2153525pe_r_spectives
petrifactions2083565petr_ifactions
preproductions2153945prepro_ductions
projections2258475__pro_jections
prosecutions1645615__pros_ecutions
prospecting1845855__prospecti_ng
prospectors1754585__prospect_ors
protections15510705__pro_tections
reassertions1253645re__assertions
recollection1654855re_collection_
reconceptions1965125re_conceptions
reconnection1655995re_connection_
reconvictions2054875re_convictions
recreations13412255recr___eations
redirections1546185re__directions
reelections13167945re___elections
refections151811645re____fections
reflections16178555re___flections
refractions16127725refr___actions
reinfections1745325re__infections
reinjections2144405re__injections
reinsertions1245285re_ins_ertions
reinspecting1763205re_inspecti_ng
reintroductions1862155reintro_ductions
rejections191510105re____jections
reoperations14410065re__o_perations
repositions131110165re_pos__itions
repossessions1453075re_possessions
reprobations1647775repro__bations
reproduction1765655repro_duction_
resection111613275re___s_ection_
resorptions1347235re_sorp__tions
respecting1549885re___specti_ng
restrictions1449295restr___ictions
resurrections1553465re_surrections
retentions101611115ret____entions
retorsions1045715retors____ions
retortions1049145ret_o___rtions
retraction121310535retr___action_
retranslations1454215retranslations
retributions14134945retr__ibutions
retroacting1447285retro__acti_ng
retrocession1494455retro_cession_
retrodicting1654465retro_dicti_ng
retroflexion2262075retrofle_xion_
retrogradations17151645retrogradations
retrogression14103425retrogression_
retroreflection20111675retroreflection_
retroversion1573675retro_version_
trajections2044515__tr_ajections
transections1446765__transections
transfections1854855__transfections
trisection1245985__tris_ection_
venesections1752935ve_nes_ections

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 Filter178691950240.360496363.9
2DLD Change Limit95024997.29613024.1
3Display Results99990.0631571.4
 (SQL Overall)178691997.71923149.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.