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

100 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
rapturing124536(None) 
capturing1436621capturing
rupturing1244351rupturing
enrapturing1452342enrapturing
fracturing1643932fracturing
maturing1139962ma_turing
pasturing1238432pasturing
recapturing1643762recapturing
repouring12310072repouring
vapouring1544652vapouring
abjuring1834883_abjuring
adjuring1735103_adjuring
alluring939073_alluring
altering91917123_altering
armaturing1353973armaturing
armouring1244983armouring
assuring937773_assuring
attiring939483_attiring
attuning935903_attuning
auguring1036383_auguring
bantering122414243bantering
baptising1446093baptising
baptizing2345843baptizing
bartering122313653bartering
battering122715153battering
cantering122417383cantering
capering132414973cap_ering
capsuling1444543capsuling
catering112019923ca_tering
chaptering18107963chaptering
cloturing1245473cloturing
cratering12312653cra_tering
culturing1236553culturing
factoring1537543factoring
faltering132211123faltering
favouring1644023favouring
featuring1337323featuring
gartering112111593gartering
gesturing1136653gesturing
hachuring1845123hachuring
haltering132212013haltering
inpouring1236393inpouring
labouring1236213labouring
lappering14258843lappering
lecturing1237303lecturing
manuring1139223ma_nuring
martyring1535783martyring
mastering122315313mastering
mattering122314063mattering
nattering102212223nattering
nurturing1045013nurturing
paltering122612903paltering
papering132213313pap_ering
pastoring12310853pastoring
pattering122314433pattering
picturing1436033picturing
posturing1238993posturing
pouring103115863__pouring
rafting113815753raft__ing
ragouting1134893ragouting
ranting84025413rant__ing
raping94829853rap___ing
rappeling1435963rappeling
rapping123619103rap__ping
raptorial1147433raptorial
rapture937393raptur__e
raptured1155473raptur_ed
raptures1037583raptur_es
rapturous1144063rapturous
raring74332873ra___ring
rating74938703ra_t__ing
rattening10288763rattening
ratting83822363ra_t_ting
rattling92510873ra_ttling
razoring1836443ra_zoring
realtering1139473realtering
reassuring1155943reassuring
renaturing11176813renaturing
repairing12310013repairing
reputing112412603rep_uting
restoring10314623restoring
restring91518783rest_ring
retiring92717413r_etiring
retuning9311583r_etuning
returning1038133r_eturning
rumouring1244513rumouring
savouring1335193savouring
suturing9310373_suturing
tabouring1245723tabouring
tapering112112503tap_ering
tattering102212333tattering
texturing1735223texturing
torturing1036253torturing
upturning1263373_upturning
vaporing1437653vap_oring
venturing1337553venturing
vesturing1337203vesturing
waitering13310723waitering
watering122316323wa_tering
yattering132410453yattering

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.486367677.0
2DLD Change Limit1486411007.36020195.8
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.89222642.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.