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

126 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
mandrils113849(None) 
mandrels1137311mandrels
mandril1049351mandril_
mandrill1146611mandrill
mandrills1245451mandrills
handrails1346512handrails
mandarins12410392mandarins
mandrel1038682mandrel_
spandrils1244162spandrils
tendrils946442tendrils
aldrins8310203_aldrins
androids1047753_androids
andros7313303_andr_os
angrily1137723_angrily
anils56326723_an__ils
anurias7312253_anurias
anvils9219713_an_vils
arils58732203_a__rils
baldrics13164893baldrics
banderols1245953banderols
bandies104124863band_ies
bandits103814793band_its
bawdrics16153273bawdrics
bawdries14136843bawdries
canaries10318943canaries
candids113812693cand_ids
candies104125613cand_ies
cantrips12318933cantrips
dandies94121443dand_ies
dandily12279633dand_ily
dandriff1694173dandriff
dandriffs1792313dandriffs
endrins8312163_endrins
fantails1139693fantails
gangrels1094973gangrels
gantries91413793gantries
handbill14115163handbill
handbills15114743handbills
handfuls15115753handfuls
handgrips1643643handgrips
handily143610873hand_ily
handrail1247303handrail_
handsels12317253handsels
indris7311963_indri_s
landfill1253883landfill
landfills1343413landfills
langrels9106173langrels
laundries1045563laundries
madras94316433ma_dr_as
madres93718183ma_dr_es
madrigals13856243ma_drigals
mails76037783ma___ils
mainsails1144853mainsails
malarias10313773malarias
manakins14209763manakins
mandala10310213mand_ala
mandalas1139443mandalas
mandalic1347803mandalic
mandamus1345523mandamus
mandarin11411023mandari_n
mandates11314093mandates
mandible1337543mandible
mandibles1445543mandibles
mandola1039023mand_ola
mandolas1139133mandolas
mandolin1148583mandolin
mandolins1248433mandolins
mandrake1546003mandrake
mandrakes1646353mandrakes
mangels103614493man_gels
mangily1339753man_gily
manias84029033man__ias
manics103919933man__ics
manikins14189723manikins
manila84518303man__ila
manilas93915873man__ilas
manlily1238743man_lily
manorial10311083manorial
manors84420883manor__s
mantels94515043man_tels
mantids103113623man_tids
mantis83926033man_ti_s
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantr_as
mantric11311353mantri_c
manuals9311223man_uals
manumits1246003manumits
manurers1037593manurers
manures9313353manur_es
manurial1047793manurial
manuring1139223manuring
marls75535163ma__r_ls
marries93825283ma_rries
materials11510803materials
materiels1147833materiels
maundies1137853maund_ies
meandrous1245013meandrous
midribs1235513m_idribs
minerals10311393minerals
misandries1345063misandries
monandries1344513monandries
mongrels1135333mongrels
monofils1346963monofils
monorails1148743monorails
nandins8312003nand_ins
panbroils1343223panbroils
pandies104224503pand_ies
pandits103914213pand_its
panfries13149203panfries
pantries101817393pantries
randies84225663rand_ies
sandals82715203sand_als
sandhis1139993sandhi_s
sandpile1146773sandpile
sandpiles1246303sandpiles
sandpits1146843sandpits
sangrias938373sangrias
spandrels1243253spandrels
spandril1144093spandril_
sundries9312023sundries
sundrily1246063sundrily
tawdries12136083tawdries
tawdrily1542733tawdrily
tendril836783tendril_
vandals113211663vand_als

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621266.48322545.4
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.95225703.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.