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

139 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
devisor1135704(None) 
deviser114212391deviser
devisors12347251devisors
divisor11345571divisor
revisor10388731revisor
advisor11134162advisor
derisory1245162derisory
deviator1248312deviator
devisal1136912devisal
devise104215752devis_e
devised123712562devised
devisee113812712devisee
devisers12339862devisers
devises114116762devises
divisors12255692divisors
previsor13116302previsor
reviser104114662reviser
revisors11379062revisors
revisory14306012revisory
seisor63712342se_isor
visor82512832__visor
adviser11135783adviser
advisors12143903advisors
advisory15132943advisory
aviso85713963_aviso_
avisos95410483_avisos
benison937123benison
bevor101510813bev__or
censor84011293ce_nsor
deair65817193deai__r
debaser103510413debaser
debtor938333de_btor
decider114213183decider
decision1148523decision
decolor1087033decolor
decor84717573de__cor
defier105118653defi_er
defiler113911883defiler
definer114413773definer
defis96717503defis__
defuser115110503defuser
dehisce13104273dehisce
deicer94114413de_icer
deiform1336693de_iform
deism84116033de_is_m
deisms94411043de_isms
deist64633593de_is_t
deists74916433de_ists
delator83015023delator
delis64928543delis__
delish105215613delis_h
delist74625053delis_t
delists84414173delists
deliver113312243deliver
delusory1273003delusory
demigod1254193demigod
demise94618323demis_e
demised113613683demised
demises103719563demises
demister11310223demister
denier74420693deni_er
denser74115193de_nser
depictor1355513depictor
deposer104011843deposer
derider93214973derider
derision939073derision
deriver114213913deriver
dervish1436983dervis_h
desirer8310783desirer
desist74818813desis_t
desists83611723desists
desorb95210203de__sorb
despiser1136343despiser
devas96218883devas__
develop13145033develop
devest104418703deves_t
devests114410473devests
deviant11311313deviant
deviate11312713deviate
deviators1358533deviators
deviatory1666443deviatory
device124512163devi_ce
devices133212583devices
devil94714733devi__l
deviled124112183deviled
devilry1433973devilry
devils104412813devi_ls
deviltry1542983deviltry
devious1138523devious
devisals1245613devisals
devisees12358283devisees
devising133111523devising
devoir1076033dev_oir
devon95113683dev__on
devour1076703dev_our
devs86424033dev_s__
dewier104013463dewi_er
divider12278953divider
diviner11369883diviner
division1266683division
dovish1338103dovis_h
editor738663_editor
evictor12346363_evictor
eviler94811893_eviler
genitor837273genitor
havior1248203havi_or
heritor10310563heritor
incisor955323incisor
lessor64010603le_ssor
levator10298963levator
levier94013873levi_er
levis85818553levis__
pavior1138533pavi_or
paviser12489093paviser
previsors14126483previsors
resistor847673resistor
reviler104314973reviler
revisal1038263revisal
revise94019743revis_e
revised113815483revised
revisers113511933revisers
revises104220533revises
revision1138713revision
revisit10311373revisit
reviver134411373reviver
savior9710173savi_or
seiser65318343se_iser
seisors73212843se_isors
seizor15428533se_izor
senior63214053seni_or
sensor63813843se_nsor
servitor1145063servitor
televisor1252313televisor
tensor63812673te_nsor
vavasor13143603vavasor
venison1036443venison
vigor92612423__vigor
visors92912223__visors
vizor173010093__vizor

Search took 7 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.406440125.6
2DLD Change Limit1340271395.92022639.7
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.38927968.5
 
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.