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

133 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
refusal105689(None) 
recusal968671recusal
refusals1164911refusals
refutal1046941refutal
medusal1035182medusal
perusal939192perusal
recusals1056392recusals
refuel93912622refu_el
refusable1476682refusable
refuse94817512refus_e
refused115114442refused
refuser104912782refuser
refuses104918552refuses
refutals1165502refutals
reposal939112reposal
revisal1038262revisal
accusal11136003accusal
arousal748633arousal
causal81413203_causal
censual937663censual
clausal936273clausal
defuel10348933defu_el
defuse105712723defus_e
defused125211093defused
defuser115110503defuser
defuses114814593defuses
deposal1037153deposal
devisal1136913devisal
equal1449823_equ_al
feudal1037683fe_udal
fugal95613033__fugal
fusel85218493__fusel
fusil84715323__fusil
ireful948713irefu__l
jejunal1342833jejunal
medusa936293medusa_
medusae1044763medusae
medusan1044713medusan
medusas1036213medusas
mensal84615663me_nsal
neural6311993ne_ural
pausal81511963_pausal
perusals1047143perusals
prebasal1244723prebasal
prefeudal1542383prefeudal
prefixal2044543prefixal
prepupal1164263prepupal
real45750293re___al
rearousal943493rearousal
reassail845753reassail
reburial1046203reburial
rebus75721113rebus__
rebuses94915293rebuses
rebuttal1043993rebuttal
recital9412163recital
recoal84117973re_coal
rectal84418133re_ctal
recusant1049463recusant
recuse85519163recus_e
recused104714423recused
recuses94619463recuses
redial74923113re_dial
refall94314393ref_all
refeel93913243ref_eel
refel84920813ref__el
refell94214443ref_ell
referral1144403referral
refill94514053ref_ill
reflag1098083ref_lag
refloat10310833refloat
refs75732243ref_s__
refuels10399523refuels
refuge105312613refu_ge
refuged125410873refuged
refugee115310943refugee
refuges115413373refuges
refugia1144313refugia
refund104810303refu_nd
refunds11448623refunds
refusers11499273refusers
refusing122310873refusing
refusnik15102113refusnik
refutable1477863refutable
refutably1785333refutably
refute95515703refu_te
refuted114313803refuted
refuter104312193refuter
refutes104515733refutes
regal65023793re__gal
reginal84814293reginal
regnal74812933re_gnal
regosol844883regosol
regular838423regular
removal1236733removal
remuda936823remuda_
remudas1035833remudas
renal55929503re__nal
renewal1038703renewal
rental63922023re_ntal
repeal84718283re_peal
reposals1037403reposals
reprisal1045903reprisal
requital1745053requital
resail64418733re__sail
resale64025543re__sale
resat55139683re__sat
resaw84117253re__saw
resay85320543re__say
reseal64819643re_seal
retial64724993re_tial
retinal75318353retinal
retotal739843retotal
retral64419743re_tral
retrial7615553retrial
retuse66617223retus_e
reusable10811273re_usable
reuse56025363re_us_e
reused75419563re_used
reuses66025523re_uses
reveal94115053re_veal
reversal1145843reversal
revisals1136813revisals
revival1337033revival
ritual6310623ritu_al
rueful948203ruefu__l
rugal65916093r__ugal
rural55821173r__ural
sensual738053sensual
serosal7311153serosal
serumal938783serumal
sexual1338413sexu_al
spousal965533spousal
versal93013753ve_rsal

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271336.83019623.3
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.31224438.0
 
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.