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

123 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
operation1131400(None) 
operations12312951operations
aeration8319932_aeration
cooperation15410022cooperation
iteration9515032iteration
moderation1348652moderation
operatic1249932operati_c
operatics1346952operatics
operating12313722operating
operational1347522operational
operative141110552operative
operator10310092operat_or
oration71617712o__ration
overaction1547992overaction
reoperation13410902reoperation
toleration1048962toleration
aberration1267203aberration
adoration10311313adoration
aerations9317903_aerations
alteration10612903alteration
aspiration1249993aspiration
botheration1654653botheration
ceratin93020163_cerati_n
chelation1439963chelation
coloration12913183coloration
cooperations1659193cooperations
copulation141111953copulation
corporation151210653corporation
creation102816513cre_ation
cremation13511643cremation
crenation11412923crenation
deaeration11313013deaeration
delation92318083_delation
desperation14510113desperation
duration9312693_duration
elation73620453__elation
elevation1239233elevation
enation73419233__enation
enervation1369473enervation
epilation11312963epilation
erasion7311963__erasion
execration1949833execration
exertion15310083exer_tion
exoneration1847653exoneration
expiration19610713expiration
federation1449573federation
fetation11613143_fetation
gelation93014433_gelation
generation11312423generation
gyration1237763_gyration
hydration1646073hydration
ideation9310493ide_ation
impetration1545903impetration
iterations10413823iterations
keratin113314153_kerati_n
laceration1249573laceration
legation92412933_legation
liberation1269993liberation
libration111510163libration
literation10511413literation
maceration1449613maceration
migration12179703migration
moderations1448273moderations
narration9310063narration
negation92913023_negation
nervation12610243_nervation
nitration9313443nitration
numeration12137963numeration
oblation1039863o_blation
observation1665053observation
obturation1297143obturation
obviation1446093obviation
operagoing1443583operagoing
operate9615733operat__e
operated11512223operat_ed
operates10515413operat_es
operationism1655863operationism
operationist1457943operationist
operatives15117883operatives
operators11410753operators
operon8811773oper___on
option83612713op___tion
orations81515803o__rations
ovation101510023o__vation
overactions1648213overactions
overcaution1655153overcaution
ovulation1238983ovulation
oxidation1746323oxidation
ozonation1845673ozonation
parathion1446173_parathion
peltation11312963_peltation
perdition1249013_perdition
pereion9312053_per_eion
permeation14410563_permeation
peroration12316003_peroration
pertain92714963_pertai_n
pervasion1446073_pervasion
petition10711753_petition
population14810023population
portion9615493_por_tion
potation101716783_potation
predation12313463predation
proration11415983proration
pupation1269503_pupation
purgation1247393_purgation
ration64226013___ration
relation82619773_relation
reoperations14410063reoperations
reparation12612723reparation
sedation9312453_sedation
separation12510433separation
seriation9318063_seriation
serration9414063serration
speciation1449393speciation
supernation13411663supernation
titration9310543titration
tolerations1158133tolerations
ulceration1247263ulceration
venation11513503_venation
veneration13412343veneration
vernation12311083_vernation
vexation1838783_vexation
vibration14138203vibration

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411236.28323657.6
3Display Results1231230.0602050.0
 (SQL Overall)1786911236.76326421.9
 
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.