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

73 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
trollops104481(None) 
trollop944791trollop_
trollopy1343271trollopy
collops112611752_collops
dollops10287962_dollops
lollops9227442_lollops
rollmops1243002_rollmops
scollops12235702scollops
trollers83211212trollers
trolleys11315692trolleys
trollies8310232trollies
trolls64613942troll__s
troops85712782tro__ops
apollos946793apollo_s
brillos9369183brillo_s
brollies1039533brollies
collop107312313_collop_
criollos1043713criollo_s
dollop9259363_dollop_
drolls75312393droll__s
droops95110963dro__ops
follows13409923_follows
gallops103211653_gallops
holloas103814943_holloas
holloes103818193_holloes
holloos104013583_holloos
hollos95320633_hollo_s
hollows134412333_hollows
lollop8238783_lollop_
lollopy12234773_lollopy
orlops847303__orlops
prologs103512133pro_logs
rollers73117473_rollers
rollmop1142993_rollmop_
rollout7811943_rollout
rollouts8136733_rollouts
rolls55326233_roll__s
rolltop944043_rolltop_
scallops12297393scallops
scollop11275433scollop_
shallops13288323shallops
strollers937563strollers
strolls739183stroll__s
tallols73311363t_allols
tallows103313743t_allows
teraflops1443063teraflops
thallous1136523thallous
tholos94213003tho_lo_s
tollers73217463t_ollers
tolls54728433t_oll__s
toluols735823t_oluols
toolless836343toolless
treetops1045463treetops
trellis739873trell_is
trillers83613493trillers
trillions947183trillions
trills64319853trill__s
trogons83410723tro_gons
troilus736413troil_us
trolands936423trolands
troll54416533troll___
trolled84312263troll_ed
troller73913173troll_er
trolley10328753troll_ey
trollied935903trollied
trolling93212493trolling
trollings10286693trollings
trolly94012363troll__y
tromps104911703tro__mps
troop76417533tro__op_
troublous1143963troublous
trulls64110283trull__s
wallops123410413_wallops

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 Filter1786911461620.453394461.4
2DLD Change Limit146162737.76618820.8
3Display Results73730.0302433.3
 (SQL Overall)178691738.24921662.1
 
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.