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

81 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
retortions104914(None) 
retorsions1045711retorsions
retortion949671retortion_
extortions1746472extortions
preportions1548262preportions
remotions1149702remo_tions
resorptions1347232resorptions
restorations12410952restorations
retentions101611112retentions
retorsion946502retorsion_
retorting10613272retorti_ng
abortions1147783_abortions
apportions1446283apportions
contortions1348683contortions
decoctions1547143decoctions
decorations14312883decorations
demotions1258443demo_tions
desertions1139883desertions
desorptions1445993desorptions
detections131410043detections
detentions11148803detentions
detonations1239373detonations
detritions1148953detritions
devotions1356593devo_tions
distortions1246613distortions
emotions10610283_emo_tions
exertions1639763_exertions
extortion1646723extortion_
fetations12511383fet_ations
perorations13314063perorations
petitions11511083pet_itions
portions10514413__portions
prenotions1248293preno_tions
preoptions1447643pre_options
preportion1448873preportion_
pretorians1258313pretor_ians
proportions1548463proportions
reactions11711713re_actions
reapportions1653653reapportions
recautions1247813recautions
receptions1449743receptions
recordations1548643recordations
recursions1245403recursions
redactions1359133redactions
reductions1359583reductions
reeditions1147653reeditions
refections151811643refections
reflations13311233reflations
reformations1747603reformations
reiterations12410873reiterations
rejections191510103rejections
relations92418333re_lations
relictions12310023relictions
relocations13311143relocations
remotion10410233remo_tion_
renditions1149183renditions
renovations1448423renovations
reparations13611663reparations
repletions1247473repletions
reporting12513903reporti_ng
repositions131110163repositions
resections121513033resections
resolutions11117793resolutions
resorcins1146983resorci_ns
resorption1247253resorption_
resorting10614613resorti_ng
restations10315843restations
restoration11412093restoration_
retardations1396513retardations
retention91611483retention_
retorters938773retort_ers
retorts76016513retort___s
retractions13910353retractions
retrains8314533ret_rai_ns
retroactions1447073retroactions
reversions1347573reversions
revocations16410313revocations
revolutions1497633revolutions
rotations91613843rot_ations
torsions839183__torsions
tortious839023__tortious

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603818.54616452.5
3Display Results81810.0461760.9
 (SQL Overall)178691818.74820426.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.