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 “movie” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
movie10531913(None) 
mavie104722561mavie
monie75631651monie
move96630721mov_e
movies115118451movies
moxie144018121moxie
bogie89524102bogie
bovid111011622bovid
bovine11712432bovine
cavie104621592cavie
civie103716352civie
cosie74728262cosie
cove95837072cov_e
covin105621122covin
cozie163519132cozie
dobie84920332dobie
dogie75222792dogie
dove85131562dov_e
dowie94721142dowie
doxie136017152doxie
fogie96719002fogie
homie104622532homie
hove107132222hov_e
looie55624242looie
louie55023512louie
love75234762lov_e
mamie95826002mamie
mavies114923192mavies
mavin105722952mavin
mavis105622722mavis
mobile103613542mobile
mode75840302mo_de
modi76826312modi_
moggie103210102moggie
moil65534092mo_il
moire71017322moire
moke106234222mo_ke
mole66251832mo_le
molies84429512molies
moline84422032moline
mollie83517102mollie
mome85239352mo_me
momi87524482momi_
monde85723142monde
monied94319462monied
monies83233162monies
monte75829772monte
moose76327192moose
mope86838042mo_pe
mopier103914782mopier
morae75831192morae
more67154522mo_re
morse76032702morse
moste75925082moste
mote67048082mo_te
motif10519682motif
motile83818342motile
motive113112142motive
motte75526972motte
moue65835572mo_ue
mouse77133002mouse
moved114218152moved
mover104220862mover
moves106128422moves
moving123913282moving
moxies154317402moxies
novae85913122novae
novice1138432novice
oorie53026362oorie
ovine86316642_ovine
rove75136982rov_e
soviet9720152soviet
towie85821872towie
vie65447632__vie
vogie95116662vogie
wove105624312wov_e
yowie114616452yowie
zowie174313842zowie

Search took 4 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 Filter178691538000.1701051123.5
2DLD Change Limit53800782.98618017.4
3Display Results78780.0461695.7
 (SQL Overall)178691783.20255806.1
 
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.