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 “reversal” 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
reversal114584(None) 
reversals1245201reversals
demersal1145272demersal
deverbal1444482deverbal
preverbal1643882preverbal
referral1144402referral
rehearsal1242342rehearsal
reveal94115052reve__al
revenual1144782revenual
revers94529632revers__
reverse103913742revers_e
reversed122711612reversed
reversely1544592reversely
reverser113010482reverser
reverses112513512reverses
reverso10367692revers_o
reversos11266712reversos
revisal1038262rev_isal
several1039532sever_al
traversal1243832traversal
versal93013752__versal
deferral1244353deferral
deverbals1544103deverbals
devisal1136913dev_isal
eternal72910893_eternal
federal1148533feder_al
fevers125414893fevers__
general81010933gener_al
levers94621323levers__
novercal1345683novercal
oversad11259963_oversad
oversale11313873_oversale
oversalt11312743_oversalt
oversaw13268163_oversaw
ravers94628183ravers__
reavers108320743reavers__
reburial1046203reburial
recusal968673re_cusal
referrals1243493referrals
refers93921083refers__
refusal1056893re_fusal
regental948943regental
rehearsals1351753rehearsals
reivers105117083reivers__
remedial1147543remedial
renewal1038703rene_wal
repeal84718283repe__al
reposal939113re_posal
reprisal1045903reprisal
reseal64819643rese__al
retral64419743re_tr_al
retrial7615553re_trial
reveals103812723reve__als
revel84423163reve___l
revels94220573revels__
reverable14310363reverable
reverb113912573rever__b
reverbed14269223reverbed
reverbs12368863rever_bs
revere94621253rever__e
revered112819333rever_ed
reverend12288853reverend
reverent112615093reverent
reverer103815833rever_er
reverers113113153reverers
reveres103621343rever_es
reverie103615163rever_ie
reveries112518513reveries
reverify1744813reverify
revering122918073revering
reversers12298483reversers
reversible1574903reversible
reversibly1873833reversibly
reversing132611483reversing
reversion1248093reversion
reversional1454033reversional
revert93529113rever__t
revertant12128003revertant
reverted122714713reverted
reverter114812873reverter
reverts104715043rever_ts
revery124014213rever__y
revest94623603reve_s_t
revests104413733reve_sts
revets94022173revets__
reviewal1443513reviewal
revisals1136813rev_isals
revival1337033rev_ival
rievers104311453rievers__
rivers94626543rivers__
rovers95423523rovers__
ruderal837373ruder_al
severals1137593sever_als
severs94121123severs__
traversals1353253traversals
universal1243463universal
ureteral856233ureter_al
venereal1145083venereal
verbal112513663__verbal
vernal93514213__vernal

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 Filter1786911461620.410435831.7
2DLD Change Limit1461621007.18620339.8
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.62623431.8
 
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.