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

100 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
misrely12319611misrely
miserly12329822miserly
misread10339722misread
misrule939352misrule
missel85216522missel_
missels94614812missels
direly10311563di_rely
dishelm1335833dishelm
dispel9310323dispel_
dispels10310503dispels
hirsel9138683hirsel_
hirsels10128353hirsels
hisself1335913hisself
listel64214743listel_
listels74212433listels
merely111312593m_erely
micell1098193mi_cell
milreis937323milreis
minstrel1046913minstrel_
minstrels1145693minstrels
mire66748233mi_re__
mired85729223mi_re_d
mires75640883mi_re_s
mirex146816623mi_re_x
misally121111063misally
misbill1137033misbill
miscall1139653miscall
misdeal1037663misdeal
misdeals1147233misdeals
misdealt1147983misdealt
misdeed113211053misdeed
misdeem12217873misdeem
misdrew1335833misdre_w
mise66043583mis_e__
miseat82925713mis_eat
miser75430403mis_e_r
miserere1049273miserere
misers85025703mis_ers
misery114113543mis_ery
mises74740563mis_e_s
misfed124113023misfe_d
misfeed13389683misfeed
misfield14265913misfield
misfile122611553misfile
misgrew1335523misgre_w
mishear1238393mishear
miskal123710263miskal_
miskals13369773miskals
miskeep1536403miskeep
miskept1538923miskept
mislead10419973mislead
misled94719313misle_d
mismeet113215163mismeet
mismet103722373misme_t
mispen10312173mispe_n
mispens11311073mispens
mispled12310463mispled
misrate91319143misrate
misreads11268923misreads
misrefer1346103misrefer
misrelate1147933misrelate
misrelied1247243misrelied
misrelies1149723misrelies
misruled1137083misruled
misrules1039383misrules
missal84314903missal_
missals93914433missals
misseat93617243misseat
missed94423603misse_d
missend104411373missend
missent94318713missent
misses85130873misse_s
misset85028153misse_t
missets94516573missets
missile92815403missile
misspell1244303misspell
misspelt1247273misspelt
misted93625823miste_d
mistend103812523mistend
mister84728563miste_r
misterm114314513misterm
misters93927513misters
misteuk1335893misteuk
mistily122612343mistily
mistral91013643mistral_
mistrals101212633mistrals
mistreat10313113mistreat
mistress10310703mistress
mitral81314323mitral_
mitre75522423mitre__
mitred94414343mitre_d
mitres83922073mitre_s
morel75729093m_orel_
morels84820023m_orels
morsel85815893morsel_
morsels94112663morsels
mussel83412903mussel_
mussels9419843mussels
myself1445593mys_elf
wisely122711713wis_ely

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.390458182.1
2DLD Change Limit1340271005.91022678.0
3Display Results1001000.0432325.6
 (SQL Overall)1786911006.34328171.4
 
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.