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

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

117 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
riposting123606(None) 
imposting1436812imposting
posting105622242__posting
repasting122312842repasting
reporting12513902reporting
reposing111213802repos_ing
repositing13310492repositing
repotting12511122repotting
rioting82716392ri_o_ting
roosting93411462r_oosting
accosting1446733accosting
apposing1337403appos_ing
biopsying1742453biopsying
boosting113311053_boosting
cohosting1546323cohosting
composting17178053composting
costing104323023__costing
deporting1369593deporting
deposing12129773depos_ing
depositing1446933depositing
digesting12208673digesting
disporting1439823disporting
disposing1339933dispos_ing
divesting14298483divesting
exporting1937323exporting
exposing1836673expos_ing
expositing2045353expositing
fisting113818123fi__sting
frosting12311183_frosting
ghosting1336463_ghosting
gipsying1533373gip_sying
histing113720373hi__sting
hosting114318383__hosting
impasting1436323impasting
importing1438193importing
imposing1348463impos_ing
kiboshing1972353kiboshing
listing84020593li__sting
misting103623383mi__sting
opposing1336383oppos_ing
ovipositing1752683ovipositing
pasting103826553__pasting
picoting1338883pico_ting
piloting1139693pilo_ting
pipetting1435513pipetting
pivoting1436183pivo_ting
porting103021783__porting
posing93922643__pos_ing
positing11312303__positing
postin83521033__postin_
postings112912303__postings
postins93721203__postins
potting103720893__potting
pouting103519943__pouting
prepasting15168883prepasting
priesting1239483pri_esting
proposing1439673propos_ing
ragouting1134893ragouting
rebooting12139023rebooting
recasting122414233recasting
recoating121317463recoating
reesting93118273r_eesting
reimporting1644093reimporting
reimposing1544463reimpos_ing
relisting102414353relisting
renesting102514703renesting
repassing12249423repassing
repeating122618983repeating
repenting122316553repenting
replating122217403replating
replotting1357043replotting
repolling122110203repolling
repouring12310073repouring
reputing112412603rep_uting
rerouting10311873rerouting
resisting103215313resisting
resorting10614613resorting
respotting1347113respotting
resting85031183r__esting
retasting102513413retasting
retesting102614603retesting
retorting10613273retorting
revesting132814123revesting
revolting1339633revolting
revoting12312033revo_ting
riesling939013ri_esling
rifting113515003ri__fting
righting132610853ri_ghting
rinsing82516113ri_ns_ing
ripening1138573rip_ening
riping93821613rip___ing
ripost83615003ripost___
riposte9269623ripost__e
riposted11216933ripost_ed
ripostes10239083ripost_es
riposts9279403ripost__s
ripping123315743rip__ping
rippling13197573rip_pling
ripsawing1542873ripsawing
ripsnorting1451533ripsnorting
rising74025883ri__s_ing
risking123914243ri__sking
riveting12139443ri_veting
rivetting13256413rivetting
roasting93012703r_oasting
roosing84018133r_oos_ing
rooting83522433r__ooting
rosing73925593r__os_ing
rotting82919683r__otting
rousting93913273r_ousting
routing83821093r__outing
rusting83821263r__usting
signposting1551443signposting
sporting112415463_sporting
spotting112812093_spotting
spouting113511953_spouting
wisting113519743wi__sting

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411176.76621968.8
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.23224708.4
 
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.