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

134 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
midribs123551(None) 
midrib1138241midrib_
dribs85115062__dribs
midairs1037202midairs
middies113116152middies
midis85923412mid_i_s
midriff1645512midriff
midriffs1742532midriffs
mihrabs1444202mihrabs
mirins83918902mi_rins
aldrins8310203aldrins
amidins103713103amid_ins
biddies113514493biddies
bidis86721143bid_i_s
birdies104016213birdies
citrins92614363citrins
cribs94516753__cribs
diaries83321953diaries
dibs76233683__d_ibs
didies84621833did_ies
drabs85119673__drabs
drib76823263__drib_
dries64733673__dries
drips85417233__drips
drubs85913833__drubs
endrins8312163endrins
fibrils1236843fibrils
fibrins1238633fibrins
giddies103713363giddies
hydrids15267233hydrids
indris7311963indri_s
irids66417773_i_rids
iris45732553_i_ri_s
kiddies133412283kiddies
kidvids1643113kidvids
madras94316433madr_as
madres93718183madr_es
mandrils1138493mandrils
marries93825283marries
medias93620783med_ias
medics114115353med_ics
medius93613283med_ius
megrims1276103megrims
merits8320873m_erits
metrics11312363metrics
mibs85330483m___ibs
micrify1744693micrify
microbe1338663microbe
microbes1439403microbes
microbus1456033microbus
microns113814783microns
micros104115363micr_os
midair937993midai_r
midbrains1443713midbrains
middays14335663middays
middens11379383middens
middles113415303middles
midges103516483mid_ges
midgets113910253midgets
midguts11296013midguts
midi75628483mid_i__
midiron1046003midiron
midirons1145883midirons
midlegs1156323midlegs
midlife13248303midlife
midline102315103midline
midlines112613333midlines
midlist10312513midlist
midlists1137523midlists
midlives14287463midlives
midrash1335423midrash
mids76541793mid___s
midships1645693midships
midsize1946393midsize
midsts95510053mid_sts
midways16386183midways
midwife16225523midwife
midwifes17234713midwifes
midwives17274803midwives
mihrab1335523mihrab_
mikrons13428413mikrons
milnebs11113793milnebs
milreis937323milreis
mimics1289363mi_mics
minibus1136343mi_nibus
minims104514813mi_nims
minis75432993mi_ni_s
minnies93617363minnies
miosis83615163miosi_s
miotics112710653miotics
mires75640883mi_r_es
miri66730373mi_ri__
mirier83918363mi_rier
miriest93619823mi_riest
mirin75023153mi_ri_n
miring93723803mi_ring
mirks115122143mi_r_ks
mirrors938623mirrors
mirs66940573mi_r__s
mirths114912993mi_rths
mirzas1738183mi_rzas
misaims11310113misaims
misbias1139083misbias
misdraws1445753misdraws
misdrive1446683misdrive
misdrives1546213misdrives
miseries10320403miseries
misfits12279663misfits
mishits122513083mishits
mislies92922283mislies
missies93423983missies
missis84417503missi_s
mitis75425993mi_ti_s
mitres83922073mitr_es
mitring103514143mitring
morris83814733morri_s
muddies113513953muddies
mudras94212263mudr_as
murids93212193m_urids
murries94118673murries
nitrids8269633nitrids
nitrils72810703nitrils
pidgins11259123pidgins
redries83721713redries
ribs65833023___ribs
ridgils9326573ridgils
smidgins12314843smidgins
tidbits1035183tidbits
tiderips1145383tiderips
tidies74721833tid_ies
updries10209083updries
vibrios1235803vibrios
vitrics12198553vitrics
widdies123514033widdies

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.423422437.4
2DLD Change Limit1340271346.87619492.0
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.34524328.3
 
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.