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

199 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
deporting136959(None) 
dehorting1447211dehorting
departing1349511departing
reporting12513901reporting
decocting1538122decocting
decorating14312072decorating
deforcing1636062deforcing
deforming1636702deforming
dehorning1455242dehorning
demoting12311422demo_ting
denoting10311752deno_ting
deperming1537112deperming
depicting1537812depicting
depleting1378192depleting
deploring1337852deplor_ing
deponing121211212depo_ning
deposing12129772depo_sing
depositing1446932depositing
depurating1438642depurating
deputing12238792dep_uting
deserting11713142deserting
desorbing1346362desorbing
devoting1338822devo_ting
deworming1635042deworming
disporting1439822disporting
exporting1937322exporting
importing1438192importing
porting103021782__porting
repotting12511122repotting
resorting10614612resorting
retorting10613272retorting
sporting112415462_sporting
aborting11710253_aborting
assorting1037303assorting
besotting12256873besotting
beworming1734553beworming
cavorting1536063cavorting
comporting17199163comporting
darting94020663d__arting
deaerating12311563deaerating
deairing10311893deair_ing
debarking1735383debarking
debarring1335723debarring
debating123213733de_bating
debiting122511203de_biting
deboning12109153debo_ning
debuting12268633de_buting
decanting132510633decanting
decerning1337293decerning
decoding132410053deco_ding
decoying15208763deco_ying
decrying15237413de_crying
decurving1634723decurving
deducting1436843deducting
defatting1436103defatting
defeating142311973defeating
defecting162510223defecting
deferring1436143deferring
deflating142610713deflating
defoaming1645653defoaming
defogging1653863defogging
deforesting1654793deforesting
defrosting1544493defrosting
degerming1435753degerming
degusting1236163degusting
dejecting20217793dejecting
delating103119603de_lating
deleting103314423de_leting
delisting112710503delisting
delousing1136303delousing
demarking1736773demarking
demasting1338453demasting
dementing13311043dementing
demerging1436643demerging
demeriting1448683demeriting
demitting13239073demitting
demobbing1743493demobbing
demoing11311753demo__ing
demounting1444963demounting
demurring1335253demurring
denting94422183de__nting
deorbiting1445153de_orbiting
depainting14156153depainting
depending14208783depending
depeopling1642643depeopling
depilating1439193depilating
deplaning1338053deplaning
deploying1636153deploying
depluming1544713depluming
deport94922393deport___
deported1249703deport_ed
deportee11510353deport_ee
deportees1256643deportees
deporter1169393deport_er
deporters1277793deporters
deportment1546773deportment
deports105012883deport__s
depraving1635973depraving
depriving1636403depriving
derating103222283de_rating
deratting1139513deratting
derogating1348633derogating
desalting1138843desalting
descrying1635103descrying
deserving1497903deserving
desiring10312143desir_ing
desisting112810383desisting
desolating1239463desolating
despiting13179323despiting
despoiling1445113despoiling
desponding1555663desponding
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
detonating1248823detonating
detouring1136973detouring
detoxing1736313deto_xing
devesting14249903devesting
deviating14311083deviating
devoicing16145223devoicing
devolving1733983devolving
devouring1435953devouring
dewooling1444323dewooling
disparting1438933disparting
distorting1239593distorting
diverting142410333diverting
divorcing1644323divorcing
doating93816863d__oating
doting84821913d__o_ting
dotting93314483d__otting
emoting10313563_emo_ting
epoxying2133033_epoxying
escorting1237713escorting
everting122213133_everting
exerting162211153_exerting
exhorting2045733exhorting
experting1938053experting
extorting1746763extorting
hearting12513123he_arting
homeporting1953053homeporting
imparting1437243imparting
imposting1436813imposting
intorting10311413intorting
leporine1049303lepor_ine
parting103527383__parting
perorating13313133perorating
poring94227273__por_ing
porking143515813__porking
posting105622243__posting
potting103720893__potting
pouting103519943__pouting
presorting1339983presorting
purporting1543793purporting
rebooting12139023rebooting
reboring11312783rebor_ing
recoating121317463recoating
recording131311623recording
recorking16149643recorking
reexporting2143423reexporting
reforging1437663reforging
reforming1538563reforming
regorging1236823regorging
reimporting1644093reimporting
reparking1638923reparking
repasting122312843repasting
repeating122618983repeating
repenting122316553repenting
reperking1638703reperking
replating122217403replating
replotting1357043replotting
repolling122110203repolling
reposing111213803repo_sing
repositing13310493repositing
repouring12310073repouring
reprobing1438073reprobing
reproving1538413reproving
reputing112412603rep_uting
rerouting10311873rerouting
resorbing1269353resorbing
respotting1347113respotting
reverting132315133reverting
revolting1339633revolting
revoting12312033revo_ting
rewording14158543rewording
reworking17136873reworking
riposting1236063riposting
separating1348643separating
shorting122514803_shorting
snorting92613373_snorting
sorting83221813__sorting
spirting112913633_spirting
sporing104319413_spor_ing
spotting112812093_spotting
spouting113511953_spouting
spurting113111633_spurting
supporting1545563supporting
teleporting1453273teleporting
vaporing1437653vapor_ing

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.420425454.8
2DLD Change Limit1486411997.84318952.1
3Display Results1991990.0962072.9
 (SQL Overall)1786911998.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.