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

104 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
intermale1171229(None) 
intervale12911581intervale
interage9314482inter_age
interface14410162interface
interfile12411042interfile
interlace11311902interlace
intermat101114612interma_t
intermats111412452intermats
internal8414072internal_
internals9712722internals
interrace11312542interrace
interval11710442interval_
intervales131010502intervales
intervals12810132intervals
antimale10312463ant_imale
enterable11312643enterable
enteral73516433enter_al_
inerrable11410153in_errable
inferable14411263inferable
infernal1186823infernal_
infertile1248673infertile
informal1355643informal_
innersole944333innersole
innervate1246593innervate
integrable1348403integrable
integral946783integral_
integrals1046463integrals
integrate10911143integrate
interact10316463inter_act
interbank1547033interbank
intercalate13117703intercalate
intercaste1249273intercaste
intercede121210983intercede
intercell1148163intercell
interclan1148603interclan
interdealer1245763interdealer
interfaced1647933interfaced
interfaces15410403interfaces
interfere12410813interfere
interfiled1447653interfiled
interfiles1349993interfiles
interfold13137483interfold
interfuse1247433interfuse
intergang11117883intergang
intergrade1247363intergrade
interlaced1349223interlaced
interlaces12412043interlaces
interlaid1049353interlaid
interlap1048593interla_p
interlaps1148233interlaps
interlard1048453interlard
interlay11310043interla_y
interlayer1346923interlayer
interlays1248083interlays
interleave1347613interleave
interline91218003interline
interlope1149183interlope
interlude1047293interlude
intermarry1564143intermarry
intermatted1476303intermatted
intermeddle1553243intermeddle
interment11419223interment
intermesh1446703intermesh
interminable1656893interminable
intermingle1445763intermingle
intermit101213593interm_it
intermits111212203intermits
intermix17156873interm_ix
intermixed2046103intermixed
intermixes1948393intermixes
intermodal1346173intermodal_
intermont11513573intermont
internalise111510553internalise
internalize20149583internalize
internally13410093internally
interne73218143inter__ne
internee82718513inter_nee
internode1048763internode
interphase1545993interphase
interplay1447163interplay
interpled1239603inter_pled
interpose11410463interpose
interspace1446143interspace
interstage1176403interstage
interstate10710973interstate
intertie8317613inter_tie
intertill9410413intertill
intervalley1754693intervalley
intervene12912243intervene
interwar1148263interwa_r
interweave1646253interweave
interwove1547143interwove
interzone1849353interzone
intestate9159873intestate
inthral10249463inthr_al_
inthrall11247063inthr_all
inthrals11258493inthr_als
intimae9109743int_ima_e
intimal9109933int_imal_
intimate101013823int_imate
invertase1245823invertase
iterate71119103i_ter_ate
littermate1243193littermate
supermale1349983supermale

Search took 9 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411048.08018396.2
3Display Results1041040.0601733.3
 (SQL Overall)1786911048.29621539.4
 
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.