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

160 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
devisal113691(None) 
devisals1245611devisals
revisal1038261revisal
decimal1238082decimal
denial74720512deni_al
deposal1037152deposal
despisal1144672despisal
devil94714732devi__l
devisable1546852devisable
devise104215752devis_e
devised123712562devised
devisee113812712devisee
deviser114212392deviser
devises114116762devises
devisor11357042devisor
revisals1136812revisals
revival1337032revival
aecial84817313aeci_al
aerial64625713aeri_al
cervical1546853cervical
datival1135583datival
deal56347413de___al
deasil71110983de_asil
decadal1137243decadal
decal85523233de__cal
decanal1038113decanal
decibel1235993decibel
decidual1244203decidual
decimals1345863decimals
decrial10310323decrial
dedal75719023de__dal
defis96717503defis__
dehisce13104273dehisce
deicidal1245713deicidal
deifical1445543deifical
deil56231623de_i__l
deism84116033de_is_m
deisms94411043de_isms
deist64633593de_is_t
deists74916433de_ists
delis64928543delis__
delish105215613delis_h
delist74625053delis_t
delists84414173delists
demersal1145263demersal
demisable1448533demisable
demise94618323demis_e
demised113613683demised
demises103719563demises
denials84114133deni_als
dental74319173de_ntal
dentinal939503dentinal
deposals1145433deposals
deprival1444603deprival
dermal93614343de_rmal
dervish1436983dervis_h
desalt7518313de__salt
desist74818813desis_t
desists83611723desists
despisals1243503despisals
detrital946573detrital
deva85720983dev__a_
devas96218883dev__as
devel94217123dev__el
deverbal1444483deverbal
devest104418703deves_t
devests114410473devests
deviant11311313deviant
deviate11312713deviate
device124512163devi_ce
devices133212583devices
deviled124112183deviled
devilry1433973devilry
devils104412813devi_ls
devious1138523devious
devisees12358283devisees
devisers12339863devisers
devising133111523devising
devisors12347253devisors
devs86424033dev_s__
dextral1577003dextral
dial55935063d__i_al
digital937063digital
dismal92412243d__ismal
distal73615763d__istal
dividual1344053dividual
divisor11345573divisor
domical1239373domical
dorsal74613943d_orsal
dossal75510303d_ossal
dovish1338103dovis_h
epical10413393_epical
evil75318073_evi__l
fecial114714623feci_al
ferial94621253feri_al
fetial95716193feti_al
gavial10310083gavi_al
geminal10109893geminal
genial74917613geni_al
genital849793genital
geoidal936703geoidal
helical12311153helical
incisal947373incisal
invital1046953invital
jovial1636543jovi_al
kevil12399863kevi__l
levis85818553levis__
lexical1637363lexical
medial93819863medi_al
medical12312513medical
medusal1035183medusal
menial84223033meni_al
meniscal1246183meniscal
mensal84615653me_nsal
mesial84818083mesi_al
metical11315363metical
oedipal1045173oedipal
ovisac1153953_ovisac
penial84120893peni_al
perusal939193perusal
recital9412163recital
recusal968673recusal
redial74923113redi_al
refusal1056893refusal
reginal84814293reginal
reposal939113reposal
reprisal1045903reprisal
retial64724993reti_al
retinal75318353retinal
reveal94115053rev_eal
reversal1145843reversal
reviewal1443513reviewal
revisable1437993revisable
revise94019743revis_e
revised113815483revised
reviser104114663reviser
revises104220533revises
revisit10311373revisit
revisor10388733revisor
revivals1435433revivals
seismal937303se_ismal
seminal91213403seminal
serial64625853seri_al
serosal7311143serosal
several1039533several
sisal54217733__sisal
telial65815363teli_al
vasal85516293__vasal
veinal93812963ve_inal
venial94218283veni_al
versal93013753ve_rsal
vesical12159813vesical
vial76731093__vi_al
vinal85725813__vinal
viral86419593__viral
visa76323873__visa_
visas84317653__visas
visual938803__visual
vital84819673__vital
xenial133414903xeni_al

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.1561145455.1
2DLD Change Limit1340271607.75017293.8
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.96922423.3
 
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.