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

227 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
revealer11311007(None) 
repealer103210701repealer
revealed123211211revealed
revealers12318241revealers
reveler104116341reve_ler
reveller112912181reveller
beveler124010682beve_ler
beveller13387662beveller
leveler10399902leve_ler
leveller11317592leveller
raveler104212462rave_ler
raveller11339262raveller
realer63528592r__ealer
reeler63822572re_e_ler
regaler83814622re_galer
reheater113413032reheater
releaser839502releaser
repealed113211872repealed
repealers11278842repealers
repeater102615442repeater
repeller103010392repeller
resealed92713962resealed
reseller83412222reseller
reveal94115052reveal__
reveals103812722reveal_s
reveled113917752reve_led
revelers113414132reve_lers
revelled123712732revelled
revellers12319502revellers
revenger1237302revenger
revenuer1136892revenuer
reverer103815832reve_rer
reverser113010482reverser
reverter114812872reverter
reviler104314972rev_iler
vealer94016542__vealer
annealer845503annealer
appealer1245743appealer
beetler938033be_etler
beheader1436043beheader
bereaver1346673bereaver
beveled133811123beve_led
bevelers13389453beve_lers
bevelled14327793bevelled
bevellers14276113bevellers
dealer74122143__dealer
defeater122611663defeater
develed123611933deve_led
driveler1284693drive_ler
driveller1353853driveller
empaler11288353_empaler
evader1036813_ev_ader
evener91010623_eve_ner
eviler94811893_ev_iler
eviller1056673_eviller
feebler1235823fe_ebler
feeler93215173fe_e_ler
groveler12305843grove_ler
groveller1354233groveller
healer94221803__healer
heeler93917313he_e_ler
jeweler1735053jewe_ler
jeweller1844123jeweller
kegeler1245493kege_ler
leveled114010383leve_led
levelers11259323leve_lers
levelled12327443levelled
levellers12286043levellers
needler8388893ne_edler
pedaler103410693pe_daler
peeler83517383pe_e_ler
preheater1448913preheater
prevailer1445153prevailer
preventer1438593preventer
ravager1136553rav_ager
raveled114113633rave_led
ravelers113310863rave_lers
ravelled12419783ravelled
ravellers12257163ravellers
ravener104110733rave_ner
reader73628293r__eader
reales64934123r__eales
realter73716313r__ealter
reamer84325213r__eamer
reaper84223143r__eaper
rearer64928913r__earer
reaver94524733r__eaver
rebater93517903re_bater
rebelled113110323rebelled
recaller1039323recaller
receiver1337413receiver
recenter102715443recenter
recoaled113111783recoaled
recoiler103210493recoiler
recycler1543683recycler
redear73515173redea__r
redeemer1145323redeemer
redialed10310793redialed
redrawer1235313redrawer
reedier83815303re_edier
reefer93314363re_e_fer
reefier102912553re_efier
reeker103715593re_e_ker
reekier113111123re_ekier
reeled74725533re_e_led
reelers73520273re_e_lers
reenter73217793re_enter
refelled122810163refelled
referrer11136053referrer
regale74821453re_gale_
regaled93615953re_galed
regalers94311123re_galers
regales83520793re_gales
regear73512743regea__r
regeared1039433regeared
rehear93713223rehea__r
rehearser12265023rehearser
reheated122415003reheated
reheaters122010263reheaters
reheeled1236763reheeled
rejecter17258943rejecter
relater73723143re_later
relaxer143410223re_laxer
release7312763release_
released9310243released
releasers937323releasers
releases8313343releases
reletter81311023reletter
reloader937913reloader
remaker133813173re_maker
remember1434623remember
reneger8299493rene_ger
renewer10248693rene_wer
repaper11310023re_paper
repeal84718283repeal__
repeals94014523repeal_s
repeated113117443repeated
repeaters112811983repeaters
repelled113111573repelled
repellers11278873repellers
repenter102813863repenter
replacer12279743replacer
repleader1245383repleader
reroller8258753reroller
resale64025543re_sale_
resales74724903re_sales
rescale93215473rescale_
rescaled113311303rescaled
rescales103414573rescales
reseal64819643reseal__
reseals73917663reseal_s
reseated93220263reseated
resellers9299903resellers
resembler1344583resembler
reserver11119633reserver
resetter81511833resetter
reshaper1336913reshaper
retailer82911573retailer
retaker113714313re_taker
reteamed1138013reteamed
retear63115483retea__r
retemper1235183retemper
retracer101411883retracer
retreater9310193retreater
revalue1038153rev_alue
revalued1237023rev_alued
revalues1137883rev_alues
revamper1533533revamper
revealing132611883revealing
revealment1545543revealment
reveille1145333reveille
reveilles1245203reveilles
revel84423163reve_l__
revelator1286533revelator
revelry1335693reve_lry
revels94220573reve_l_s
revenge1138573revenge_
revenged1337553revenged
revengers1336413revengers
revenges1238983revenges
revenue1039533revenue_
revenued1237223revenued
revenuers1235983revenuers
revenues1138663revenues
reverable14310363reverable_
reverbed14269223reverbed
revere94621253reve_re_
revered112819333reve_red
reverers113113153reve_rers
reveres103621343reve_res
reverie103615163reverie_
reveries112518513reveries
reverse103913743reverse_
reversed122711613reversed
reversers12298483reversers
reverses112513513reverses
reverted122714713reverted
reverters122710433reverters
revested122612243revested
revetted122210943revetted
reviewer1434133reviewer
revile94921613rev_ile_
reviled114417923rev_iled
revilers114011693rev_ilers
reviles104421353rev_iles
reviser104114663rev_iser
reviver134411373rev_iver
revoker14419193rev_oker
revolter11279363revolter
revolver14287713revolver
rewear93011993rewea__r
reweave1336773reweave_
reweaved1535953reweaved
reweaves1436603reweaves
rivaled1138933riv_aled
riveter10208753rive_ter
sealer63928963__sealer
severer103511563seve_rer
squealer17115603squealer
stealer72913973_stealer
traveler11328433trave_ler
traveller1266603traveller
unrevealed1443683unrevealed
vealed103916323__vealed
vealers103214293__vealers
vealier102712173__vealier
veiler93814353__veiler

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.203880251.2
2DLD Change Limit1461622277.37619815.9
3Display Results2272270.1102063.6
 (SQL Overall)1786912277.68923239.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.