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

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

69 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
helicoptering216212(None) 
helicopting1952452helicopt__ing
helicopter1753503helicopter___
helicoptered2061883helicopter_ed
helicopters1853163helicopter__s
flichtering2042684_flic_htering
helicopted1852704helicopte___d
heliotyping2051844heli_o_typing
accoutering1653205__accoutering
aminopterin1563085_aminopterin_
aminopterins1663305_aminopterins
bedcovering2052665be_dco_vering
bediapering1763045bedi_ap_ering
blistering13107065_bli__stering
calipering1545005cali__p_ering
coppering162810895____coppering
decentering1546485de__centering
deciphering2053225de__ciphering
delivering1545175deli___vering
delustering1344075del__ustering
eliciting1237775_elic_it__ing
enciphering1952955_e_nciphering
encountering1583135_e_ncountering
felicitating1853325felic_itating
fellmongering20121685fellmongering
filibustering1961155filibustering
flickering2044095_flic__kering
flittering1486505_fli__ttering
glistering12106425_gli__stering
glittering1296005_gli__ttering
haltering132212015hal____tering
hectoring1538305he__c__toring
heightening1952675he_i_ghtening
helicopt1547035helicopt_____
helicopts1643805helicopt____s
helilifting1852045helilift__ing
heliometric1855235heli_ometri_c
hemipteran1753295hemi__pteran_
hemipterans1852865hemi__pterans
holstering1447085hol___stering
huckstering2152665h__uckstering
leistering1147985le_i__stering
lepidopteran1761885lepidopteran_
lepidopterans1871555lepidopterans
lepidopterist1871565lepidopterist
lightering15246115__li_ghtering
lippering14217885__li__ppering
littering102411985__li__ttering
loitering1039685__l__oitering
loppering14237285__l__oppering
peltering122011675pel____tering
plecopteran1762705_plecopteran_
plecopterans1862315_plecopterans
recapturing1643765re__capturing
recovering1647375re__co_vering
rediscovering2062035redisco_vering
reencountering1791375reencountering
refiltering1544825refi__ltering
registering1346395regi__stering
relacquering2451775relac_quering
relettering1255515rel__ettering
rencountering16122475re_ncountering
sceptering1545795___sceptering
sheltering1446495shel____tering
slipcovering2051245_slipco_vering
splintering1444295spli__ntering
telemetering1552465tel_emetering
telphering1644205tel___phering
weltering13219495wel____tering

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 Filter1786911247900.390458182.1
2DLD Change Limit124790698.91014005.6
3Display Results69690.0431604.7
 (SQL Overall)178691699.34319125.7
 
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.