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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
complaining184473(None) 
complainant1753612complainant
complainingly2361752complainingly
uncomplaining2061782uncomplaining
campaigning1952003camp_aigning
captaining1546073c_aptaining
cocaptaining19101913cocaptaining
combining1637893com__bining
compacting19177093comp_acting
companioning1952933companioning
companying2044813comp_anying
comparing162410583comp_a_ring
comparting17188383comp_arting
compassing1746553comp_assing
compiling1637763comp__iling
complain1448763compla__in_
complainants1852663complainants
complained17175793complain_ed
complainer1645693complain_er
complainers1744473complainers
complains1549193compla__ins
complaint15410253compla__int
complaints1646003complain_ts
complaisant1753233complaisant
complecting2045763complecting
completing1748423compl_eting
complexing2444743compl_exing
complotting18124263complotting
complying1936113compl__ying
compositing1846263compositing
comprising1748633comp_rising
comprizing2647463comp_rizing
containing13410933co_ntaining
cosmolining1653703cosmol_ining
coxswaining2451863coxswaining
emplaning1446533_empla_ning
explaining2044303_explaining
plaining113911553___plaining
volplaning1642473volpla_ning
calamining1545934c__alamining
calcining1447814c__alcining
chaining142810784c___haining
claiming13279304c___laiming
cochairing1844654co_chairing
cocktailing2052784cocktailing
coemploying2152414coempl_oying
coffining1845484co__ffining
coining103920544co____ining
cojoining1945754co__joining
collaging1337914co_lla_ging
collapsing1543824co_llapsing
collaring12310544co_lla_ring
collating12312764co_lla_ting
colliding1338584co__lliding
comaking1739994com__a_king
comanaging1644324comana_ging
combating16310164com_ba_ting
combatting1755144com_batting
commanding1845924com_manding
commixing2345194com__mixing
communing16207864com__muning
communising1844964communising
communizing2745234communizing
companied1648024comp_a_nied
companies15311804comp_a_nies
companion1577684comp_a_nion
companions1697264comp_anions
compeering1747054comp_eering
compelling1746554comp_elling
compering163414164comp__ering
competing163712464comp__eting
comping143518594comp____ing
complacent1846694compla_cent
complaisance2061834complaisance
complementing2253614complementing
complexifying3391074complexifying
compliance1844934complian_ce
compliances1945034compliances
compliancies2053484compliancies
compliancy2153754complian_cy
compliant1549664compl_i_ant
compliantly2053834compliantly
complicating2145634complicating
complicit1747434compl_ici_t
complicity2145694compl_icity
compliment1848404compl_iment
complimenting2252864complimenting
complin13312074compl___in_
compline14313554compl___ine
complines15312834compl_in_es
complins14313114compl___ins
comporting17199164comp_orting
composing16179844comp__osing
composting17178054comp_osting
compounding1943074compounding
compressing1846434compressing
compromising2152924compromising
compting153013604comp___ting
computing16309854comp__uting
confining1539994co__nfining
conflating16410004confla_ting
conjoining2046104co_njoining
constraining1554544constraining
coplotting1555954co_plotting
coppicing1845404co_p_picing
copulating1549374copula_ting
corelating13511584corela_ting
coupling13310784coupl___ing
couponing1446294coup__oning
cumulating1546354cumula_ting
curtaining1345534c_urtaining
deplaning1338054_depla_ning
emplacing1645484_empla_cing
enplaning1246804_enpla_ning
fountaining15103644fountaining
impainting1544504_imp_ainting
impairing1445474_imp_airing
impawning1743424_imp_awning
implanting1545324_implanting
misplanning1653874misplanning
nonplaying1644444nonpla_ying
obtaining1236774_o_btaining
oompahing1773174oomp_a_hing
opining10311744_o_p__ining
ordaining1145754_o_rdaining
orphaning1544994_orpha_ning
outgaining1237094_outgaining
outlining10310504_outl_ining
outplanning1463834outplanning
paining103920244___p_aining
plaiting113113514___plaiting
planing103418254___pla_ning
planning113610224___planning
preplanning1643694preplanning
reexplaining2251954reexplaining
remaining122212794rem__aining
replanning1345314_replanning
splining11310774__spl_ining
spraining1248154__spraining
uncomplainingly258954uncomplainingly
unplaiting1345504_unplaiting
womaning1437644wom__a_ning

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191428.61017284.4
3Display Results1421420.0761868.4
 (SQL Overall)1786911429.10919617.0
 
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.