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

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

50 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
pulsator108569(None) 
pulsators1175371pulsators
pulsatory1474611pulsatory
palpator1247122palpator
pulmotor1242812pulmotor
pulsar8329362pulsa__r
pulsate9510232pulsat_e
pulsated1136852pulsated
pulsates1048812pulsates
pulsation1137142pulsation
ablator939843abl_ator
adulator948593adul_ator
alastor739653_alastor
collator10310373collator
curator9312213cu_rator
delator83015023del_ator
dilator82712783dil_ator
emulator1048743emul_ator
epilator1049243epil_ator
fellator1176713fellator
nucleator1144873nucleator
outsavor1194253outsavor
palliator1146003palliator
palpators1346793palpators
palpatory1645213palpatory
pastor84817483p_as_tor
peculator1387863pecul_ator
pilaster1038163pilaster
piscator1246923piscator
plaster93318693p_laster
plater84427693p_l_ater
pleater93916333p_leater
predator11310053predator
pronator10311783pronator
pulmotors1342803pulmotors
pulsant9310563pulsa_nt
pulsars9358913pulsa_rs
pulsatile1173393pulsatile
pulsating1236343pulsating
pulsations1236373pulsations
pulsative1455173pulsative
pulser84215193puls__er
pulsion938393puls_ion
punster92911103puns_ter
purgatory1544413purgatory
questor16146633ques_tor
relator74016363rel_ator
spoliator1144843spoliator
ulster63712103_uls_ter
valuator1196723valuator

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit146162506.76321612.0
3Display Results50500.0163125.0
 (SQL Overall)178691507.20224811.3
 
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.