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

59 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
reburial104620(None) 
reburials1143931reburials
burial84117622__burial
reburied1137912reburied
reburies10311142reburies
rebuttal1043982rebuttal
retrial7615552re_trial
tenurial847702tenurial
aerial64625713ae__rial
burials93612083__burials
bursal84414823__bursal
centurial1147943centurial
curial84019153__curial
decrial10310323de_crial
demurral1143943demurral
eluvial1045853_eluvial
exuvial1744253_exuvial
ferial94621253fe__rial
herbarial1465383herbarial
manurial1047783manurial
memorial1249503memorial
mercurial1354723mercurial
neural6311993ne_ur_al
preludial1244873preludial
preputial1345673preputial
pretorial11512653pretorial
pretrial10511983pre_trial
rasorial848223rasorial
rebill84713243reb__ill
reboil83814683reb_oi_l
reboring11312783reboring
rebuild1036293rebu_ild
rebuilt939973rebu_ilt
rebuking1536693rebuking
rebury11349213rebur__y
reburying1535193reburying
rebuttals1142863rebuttals
rebuying1436743rebuying
rectorial11119893rectorial
recusal968673recu_sal
redial74923113re__dial
redrill857893re_drill
referral1144403referral
refugia1144313refugia_
refusal1056893refu_sal
refutal1046943refu_tal
remedial1147543remedial
remigial1146603remigial
reprisal1045903re_prisal
repurify1643803repurify
requital1745053requital
retial64724993re__tial
retral64419743re_tr_al
retrials8510823re_trials
reversal1145843reversal
rubrical1296093rub_rical
rural55821173r__ur_al
serial64625853se__rial
urial54823023___urial

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162598.62616944.4
3Display Results59590.0301966.7
 (SQL Overall)178691598.82920239.1
 
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.